I'm stuck and don't even know where to start, please help
The question: The manager is interested to know yearly borrowing volume by Gender. Present a table displaying the Gender, Year, Month and The Number of Loans. Sort the results in descending order by Gender, ascending order by Year and ascending order by Month. Show only the rows if the number of loans is less than 25. Hint: (1) Use CheckedOut date to extract the year and month when the book is loaned; (2) Use strftime() function to deal with the year and month.
Relevant tables:
Customer:
CustomerID
LastName
FirstName
Address
Suburb
City
PostalCode
Email
PhoneNumber
Gender
MemberStatus
MemberSince
Major
Loan:
LoanID
CustomerID
InventoryItemID
CheckedOut
DueDate
CheckedIn
Renewals
OverdueFee
