Library Management System

Tables: Books, Authors, Members, Loans.

Tasks: Find overdue books, most borrowed books, top readers.

SELECT m.name, COUNT(l.LoanID) AS TotalBorrowed
FROM Members m
JOIN Loans l ON m.MemberID = l.MemberID
GROUP BY m.name
ORDER BY TotalBorrowed DESC;