Question 4:
Write a query to display GenreID, GenreName of all distinct genres which have books published after 1980 borrowed in at least one loan. Display the results in ascending order of
GenreName as follows:
GenrelD
2
8
3
GenreName
Fantasy
Horror
Mystery
4
5
10
5
Poetry
Romance
1
2
3
Picture 4.1
Question 5:
Write a query to display MemberID, MemberName, Sex, NumberOfBookCopies corresponding to each female member; where NumberOfBookCopies is the number of distinct book copies borrowed in the year 2020 (based on LoanDate) by the corresponding member. Display the results in descending order of NumberOfBookCopies, then in ascending order of MemberName for rows having the same NumberOfBookCopies. Note that NumberOfBookCopies must be 0 if the member did not borrow any book in 2020.
Close
+ 98%
Zoom
