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 NumberOfBook Copies must be 0 if the corresponding genre has no book published after 1980.
6 of 6
Paper No: 2
Zoom
+ 100%
Close
