Top 5 Spenders in the Galactic Bazaar
Tables Used
customers
ColumnType
customeridbigint
nametext
speciestext
contactinfotext
loyaltystatustext
joindatetext
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
totalspent
rank

3. Top 5 Spenders in the Galactic Bazaar

Uncover the most loyal (and lucrative) patrons of Xorthax's emporium.

Xorthax wants to reward the top 5 customers based on their total order amounts. Help him find the highest spenders across the galaxy.
Write Your Query