Year
Month
NumberOfLoans
1
2015 10
7
2
2016 6
4
3
2016 11
4
4
2017 9
4
5
2018 6
4
6
2018 10
4
7
2019 1
4
8
2020 5
4
9
2020 6
4
10 2020 9
4
11 2021 12
4
12 2022 1
3
13
2022 2
3
14
2022 5
3
15 2022 7
3
16 2022 10
3
17
2022 11
3
18
2023 3
6
Question 7:
Picture 6.1
Write a query to display GenrelD, GenreName, NumberOfMale Members,NumberOfFemale Members, corresponding to each book genre, where
NumberOfMaleMembers and NumberOfFemaleMembers are respectively the number of distinct male members and female members who have borrowed in the year 2020 (based on
Zoom
+ 75%
Close