Most Borrowed Book
Easy
Library Systems
Return the title of the most borrowed book and the number of times it was borrowed.
Table schema
Books(id INT PRIMARY KEY, title VARCHAR(40))
Loans(id INT PRIMARY KEY, book_id INT, member_id INT)Sample data
Books
id | title
10 | Dune
11 | Emma
12 | Ulysses
Loans
id | book_id | member_id
1 | 10 | 1
2 | 11 | 2
3 | 10 | 3
4 | 12 | 1
5 | 10 | 2
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.