Bucket Orders by Size

easy
Unit 9 · Case0/4 to milestone

Group orders into size buckets: 'small' (total under 75), 'medium' (75 up to but not including 200) and 'large' (200 or more). Return bucket, orders (the count) and revenue (the sum of totals) for each bucket that has orders, in the order small, medium, large (not alphabetical).

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#case#aggregation1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Bucket Orders by Size · TechGradify