Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
BETWEEN, LIKE and ILIKE. BETWEEN a AND b keeps values from a to b, both ends included. LIKE matches text patterns: % stands for any run of characters, so '%Paper%' means 'contains Paper'. LIKE cares about capital letters; ILIKE ignores them. Write dates as 'YYYY-MM-DD'.
select product_name, list_price from products where product_name ilike '%paper%' and list_price between 5 and 10
Marketing is planning a mailing for print shops and wants every customer with 'Print' in its name that signed up during 2024.
Show customer_name and signup_date for customers whose name contains 'print' in any capitalisation and whose signup_date is between 2024-01-01 and 2024-12-31.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe