Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
REPLACE. REPLACE(text, find, with) swaps every occurrence of find for with. REPLACE(name, ' ', ' ') turns a double space into a single one, which TRIM can't do because TRIM only touches the ends. Functions nest, so TRIM and REPLACE can work in one expression.
select product_name, replace(product_name, ' (', ', pack of ') as label from products where category = 'Cleaning'The CRM import has names like 'sam WALSH', typed with two spaces between first and last name. Data ops wants those names fixed before the mail merge.
For contacts whose name, once its outer spaces are trimmed, still contains a double space, return contact_id and fixed_name: the trimmed name with the double space replaced by a single space.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe