13
2022 2
14
2022 5
15
2022 7
16
2022
10
17
2022
11
18
2023 3
3
3
3
3
3
6
Picture 6.1
Question 7:
Write a query to display GenrelID, GenreName, NumberOfMaleMembers,NumberOfFemale Members, corresponding to each book genre, where
7 of 7
Paper No: 7
NumberOfMaleMembers and NumberOfFemale Members are respectively the number of distinct male members and female members who have borrowed in the year 2020 (based on LoanDate) books belonging to each book genre. Note that all book genres must be displayed in the results as in the following figure.
GenrelD
1
2
1
2
GenreName Science Fiction 6
NumberOfMale Members
NumberOfFemale Members
2
1
Fantasy
4
+ 100%
Zoom
Close