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

Returned scrolls

Search for rows that do have a value using IS NOT NULL.

Task

Write a query that retrieves all columns from the wypozyczenia table for those loans that have already been returned, that is, where data_zwrotu is NOT empty. Use IS NOT NULL.