Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
JOIN. JOIN puts two tables side by side using a column they share. Customers and regions both have region_id. Short aliases (c, r) save typing.
select c.customer_name, c.region_id, r.region from customers c join regions r on r.region_id = c.region_id limit 5
Account managers want the Enterprise customers with their region name, not just a region number.
Show customer_name and region for Enterprise customers. The region name lives in the regions table.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe