Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
TRIM, UPPER and LOWER. TRIM(text) removes spaces at the start and end. UPPER(text) and LOWER(text) change the case. Text comparisons are exact, so ' c-1001' does not equal 'C-1001'. Clean both the spaces and the case before you compare, and the variants line up.
select product_name from products where upper(trim(category)) = 'CLEANING'
Meadow Clinic's account manager needs its contacts from the CRM import, where customer refs were typed with stray spaces and in either case.
Return contact_id and contact_name for every crm_contacts row whose customer_ref, with spaces trimmed and in capitals, is 'C-1053'.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe