Average Order Value by Country

easy
Unit 1 · Joins & Aggregation0/3 to milestone

Average order value (AOV) is one of the first numbers an e-commerce team looks at.

Return country, orders (the number of orders) and avg_order_value (rounded to 2 decimal places) for every country with at least one order. Sort by avg_order_value from highest to lowest, then by country.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#joins1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Average Order Value by Country · TechGradify