3
3
Mystery
4
10
Poetry
5
5
Romance
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.
5 of 5
Paper No: 6
MemberID
MemberName
Sex
NumberOfBookCopies
1
6
Amanda Jones
Female 13
2
28
Ava Lee
Female 7
3
16
Olivia Harris
Female 3
4
10
Sarah Moore
Female 3
5
26
Sophia Roberts
Female 3
6 34
Ella Adams
Female 2
7
32
Avery Scott
Female 1
8
4
Emily Williams Female 1
9
24
Olivia Wilson
Female 1
10 36
Aria Gonzalez
Female 0
11 30
Chloe Parker
Female 0
12 12
Elizabeth An...
Female 0
13 22
Emma Lopez
Female 0
14
20
Isabella Marti...
Female 0
+ 100%
Close
