T
Z
Fantasy
2
8
Horror
3
3
Mystery
4
10
Poetry
5
5
Romance
Picture 4.1
Question 5:
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.
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
Thuillan
Zoom
+ 100%
Close
