Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
NULL and IS NULL. NULL means 'no value': not zero and not empty text. Any comparison with NULL, even = NULL, is unknown rather than true, so WHERE drops the row. To find missing values write IS NULL; to keep only filled ones write IS NOT NULL.
select refund_id, amount, reason from refunds where reason is not null limit 5
On 31 December the logistics desk wants every shipment that hasn't been delivered yet, so it can chase Rapid Freight, ParcelLine and Greenway Logistics.
Show order_id, carrier and shipped_date for every shipment whose delivered_date is missing (NULL).
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe