4
24
Olivia Wilson
Female 1
10 36
Aria Gonzalez Female 0
11 30
Chloe Parker Female 0
12 12
13
22
Elizabeth An...Female 0
Emma Lopez
Female 0
14 20
Isabella Marti...Female 0
15 2
Jane Smith
16 8
Jessica Miller
Female 0
17 14
Female 0
Laura Jackson Female 0
18 40
Madison Lee Female 0
19 38
Scarlett Wright Female 0
20 18
Emily Williams Female 1
Sophia Thom... Female 0
Question 6:
Picture 5.1
Write a query to display for each year, all the months having the highest number of loans (NumberOfLoans) of the corresponding year (based on LoanDate); display the results with Year, Month, NumberOfLoans in ascending order of year, then in ascending order of month for rows of the same year. Note that if one year has many months with the highest number of loans, all these months must be displayed as with the year 2016 in the following figure.
6 of 6
Paper No: 6
+ 100%
Close
