SQLDAXExcelPython
Leaderboard
Interview classicsMedium20 points

Customers with no sale in a year

Return CustomerName for customers with no sale in 2025, including those who never bought. The filter on the year must go in the join, not in WHERE.

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.