Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Most Borrowed Book

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.