Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
AVG, SUM, MIN, MAX and ROUND. SUM, AVG, MIN and MAX work like COUNT, but on a column. ROUND(value, 2) keeps 2 decimals. You can wrap one function in another.
select max(list_price) as top_price, min(list_price) as low_price from products
Pricing wants to know what a typical Brightline product costs.
Return the average list_price of all products, rounded to 2 decimals. Name the column avg_price.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe