Customers with a Big Order (EXISTS)

easy
Unit 4 · Subqueries & Dates0/3 to milestone

Return the name and country of every customer who has placed at least one order over 100, sorted by name. Use a correlated EXISTS subquery, so each customer appears once however many big orders they have.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#subqueries#exists1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers with a Big Order (EXISTS) · TechGradify