It's a really easy SQL query. I don't know how to squeeze it crying

Books, book numbers, publishers, and year of publication are included in the relationship. (Basic key is book number)

I would like to print out the name of the publisher that has published more than 10 books in SQL since 2010

I don't think you're simply extracting it from where. I don't know how to squeeze it.

sql

2022-09-22 21:15

1 Answers

Once the name of the publisher is found, the selection attribute is only publisher, and

SELECT Publisher

And the issue year should be after 2010

 WHERE Issue Year >= 2010

For each publisher

GROUP BY Publisher

If you filter the occurrence of more than 10 books (COUNT),

HAVING COUNT >= 10

I think it's going to be SQL.

SELECT Publisher WHERE Publishing Year >= 2010 GROUP BY Publisher HAVING COUNT >= 10

SQL's GROUP BY... HAVING ...I think you can study the contents of

Note



		
		
			

				

					
				

				
					2022-09-22 21:15

			
			If you have any answers or tips



		

	
		Popular Tags
	
	python x 4647
android x 1593
java x 1494
javascript x 1427
c x 927
c++ x 878
ruby-on-rails x 696
php x 692
python3 x 685
html x 656
	


	
		Popular Questions
	
	
	1025 In Java servlet, when SHA-256 sends WW-Authenticate header for digest authentication, the client does not return the result.

	593 Scrap text information after the "View More" button when searching in the Yahoo! News search window

	638 Uncaught (inpromise) Error on Electron: An object could not be cloned

	625 GDB gets version error when attempting to debug with the Presense SDK (IDE)

	575 rails db:create error: Could not find mysql2-0.5.4 in any of the sources