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
Picture 6.1
Question 7:
Write a query to display AuthorID, AuthorName, NumberOfLoans ByFemale Members,
NumberOfLoans By Male Members corresponding to each author, where NumberOfLoans ByFemale Members and NumberOfLoans By Male Members are respectively the number of loans made in 2020 (based on LoanDate) by female members and male
7 of 7
Paper No: 6
members in which books of the corresponding author were borrowed. Note that all authors must be displayed in the results as in the following figure.
AuthorID AuthorName
NumberOfLoansByFemale Members
NumberOfLoansByMaleMembers
1 234567
1
J.K. Rowling 1 Stephen King 1
1
2
2
3
Jane Austen
2
4
4
George Orwell 3
2
5
Agatha Christie 1
2
6
Mark Twain
2
1
7
J.R.R. Tolkien 1
4
+ 100%
Close
