Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Sales ops asked the AI assistant which CRM contacts point to a customer that doesn't exist. It flagged 30 contacts, but most of them look like real customers such as c-1017 and c-1044.
AI assistant: “I cleaned customer_ref, converted it to a number with TRY_CAST so bad values don't crash the query, and kept the contacts with no matching customer.”
Run the AI query, then fix it so it returns contact_id and customer_ref (as stored) for every contact whose cleaned customer_ref (trim, upper case, remove 'C-', as an integer) matches no customer_id.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe