Coding task · SQL and MySQL course · Module 3: Filtering (WHERE)

Unreturned scrolls

Search for rows that are missing a value using IS NULL.

Task

Write a query that retrieves all columns from the wypozyczenia table for those loans that have not yet been returned, that is, where data_zwrotu is empty (NULL).