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.
7 of 7
Paper No: 2
Year Month NumberOfLoans
Close
+ 85%
Zoom
