Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
AND, OR, NOT and IN. AND needs both conditions to be true, OR needs at least one. NOT flips a condition. IN ('a', 'b') is a short way to write several ORs on one column. When you mix AND with OR, put the OR part in brackets, because AND is worked out first.
select customer_name, segment from customers where segment in ('SMB', 'Mid-Market') and not region_id = 4Facilities at Harbor & Pine Hotels want cheap restock items: anything from Cleaning or Desk Supplies that costs under 15.
Show product_name, category and list_price for products in the 'Cleaning' or 'Desk Supplies' category with a list_price below 15.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe