NumberOfBookCopies, then in ascending order of GenreName for rows having the same
5 of 5
Paper No: 11
NumberOfBookCopies as in the following figure. Note that NumberOfBookCopies must be 0 if the corresponding genre has no book published after 1980.
GenreID
GenreName
NumberOfBookCopies
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:
Zoom
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 for rows of the same year. Note that if one year has many months with the highest number of loans, all these months must be displayed as with the year 2016 in the following figure.
+ 100%
Close
