Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
COALESCE. COALESCE(a, b, …) returns the first of its values that isn't NULL. COALESCE(reason, 'Unknown') shows a label where a value is missing and the real value everywhere else. Give it values of the same type: text with text, numbers with numbers.
select contact_name, coalesce(email, phone) as reach_by from crm_contacts limit 5
The Q4 refund report goes to the finance team, who don't want empty cells. Missing reasons should read 'Not recorded'.
For refunds with a refund_date on or after 2025-10-01, return refund_id, amount and reason, showing 'Not recorded' where the reason is missing.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe