Zoom
6 of 6
Paper No: 2
GenrelD
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:
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 displaved as with the year 2016 in the following figure
+ 100%
Close
