Customers Whose Every Order Exceeds 75

medium
Unit 21 · Aggregation & Joins II0/3 to milestone

Return the name of customers who have at least one order and whose every order total is above 75. Sort by name.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#having#not-exists1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers Whose Every Order Exceeds 75 · TechGradify