Write a query to display for each year, all members having the highest number of loans (NumberOfLoans) in the corresponding year (based on LoanDate). Display the results with Year, MemberID, MemberName, NumberOfLoans in ascending order of Year, then in ascending order of MemberName for rows of the same year. Note that if one year has many members with the highest number of loans, all these members must be displayed as with the year 2016 in the following figure.
6 of 6
Paper No: 5
Zoom
+ 112%
Close
