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
	
	
	974 In Java servlet, when SHA-256 sends WW-Authenticate header for digest authentication, the client does not return the result.

	609 /usr/bin/google-chrome:symbol lookup error:/usr/bin/google-chrome: undefined symbol:gbm_bo_get_modifier

	519 The method of the class of the application that I am creating in Typescript does not work as I expected.

	546 Who developed the "avformat-59.dll" that comes with FFmpeg?

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