All SQL problems
HardCapstone
Capstone — analyst summary
One query that returns four rows — metric name + value — for a stakeholder summary: (1) total delivered revenue, (2) delivered order count, (3) average order value, (4) top city by revenue. Use UNION ALL.
- #capstone
- #analyst-screen
Schema (SQLite, in-browser)
customers (id, name, city, signup_date) products (id, name, category, price) orders (id, customer_id, order_date, status) order_items (order_id, product_id, quantity)
Sample input
the whole schema
Expected shape
4 rows: metric + value
sql-capstone.sqlSQLite
Result
Press “Run query” to execute against the sample database.