Skip to main content

7

sql

-- Students who are 'guest' members and have no overdue books
SELECT name, membership_type
FROM library_members
WHERE membership_type = 'guest' AND has_overdue_books = 'no';

-- Members who are 'guest' or borrowed more than 3 books
SELECT name, number_of_books
FROM library_members
WHERE membership_type = 'guest' OR number_of_books > 3;

-- Exclude members who have overdue books
SELECT name
FROM library_members
WHERE NOT has_overdue_books = 'yes';

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql