Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)
Readers with no loans
Combine LEFT JOIN with an IS NULL filter to find empty cross-references - readers who borrowed nothing.
Task
Write a query that lists the nazwisko of readers who have NEVER borrowed anything. Use czytelnicy c LEFT JOIN wypozyczenia w ON w.czytelnik_id = c.id and keep only the rows where w.id is NULL.