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.