Members Who Never Borrowed
Easy
Library Systems
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.