Zoom
Write a query to display GenreID, GenreName, NumberOfBookCopies corresponding to each genre, where NumberOfBookCopies is the number of copies of books published after the year 1980 of each genre. Order the results in descending order of NumberOfBookCopies, then in ascending order of GenreName for rows having the same NumberOfBookCopies as in the following figure. Note that NumberOfBookCopies must be 0 if the corresponding genre has no book published after 1980.
NumberOfBookCopies
GenreID
GenreName
1
5
Romance
21
2
3
Mystery
7
3
8
Horror
3
4
10
Poetry
2
5
2
Fantasy
1
6
9
Adventure
0
7
7
Biography
0
8
6
Historical Fiction 0
9
1
Science Fiction 0
10
4
Thriller
0
Picture 5.1
Question 6:
Write a query to display for each year, all the months having the highest number of loans (NumberOfLoans) of the corresponding year (based on LoanDate); display the results with Year, Month, NumberOfLoans in ascending order of year, then in ascending order of month
+ 100%
Close
