SQL · Advanced

Subqueries & CTEs

A query inside a query: compute the average first, then keep who beats it.

form
inner query
SELECT AVG(spend)
avg = 612
people
namecountryspend
query.sql