Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Calculated columns. Revenue isn't stored, you calculate it per order line: quantity × unit_price × (1 − discount_pct). You can SUM a calculation just like a column. Only completed orders count as revenue.
select order_item_id, quantity * unit_price as gross from order_items limit 5
Marketing wants to know which channel brings in the most revenue.
Return channel and revenue (rounded to 2 decimals) for completed orders. Revenue = quantity × unit_price × (1 − discount_pct).
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe