I have a set of records that is a list of borrowed books (book_id) and the borrower's details (member_id, category).
Each borrower belongs to a membership category (ie, Student, Teacher, Pensioner).
We want to write a query to identify, for each book, how many times it was borrowed by
members...