SQLDAXExcelPython
Leaderboard
Group and aggregateMedium20 points

High value customers

Return CustomerId and total Amount for customers whose total Amount is above 1000000.

Show solutionLifetime

Runs in your browser with DuckDB, whose SQL is close to PostgreSQL. Nothing you type is sent to a server unless you save a score.

SQLselect text to run only that part
Loading editor…

Press Ctrl+Enter or Run to see the result here.