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

Members Who Never Borrowed

Return the names of members who have never borrowed a book, ordered by name.

Table schema

Members(id INT PRIMARY KEY, name VARCHAR(30))
Loans(id INT PRIMARY KEY, member_id INT, book_id INT)

Sample data

Members
id | name
1 | Ira
2 | Jon
3 | Kai
4 | Lia

Loans
id | member_id | book_id
1 | 1 | 10
2 | 3 | 11
3 | 1 | 12

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.