SQLDAXExcelPython
Leaderboard
Group and aggregateEasy10 points

Sales lines per year

For each year of OrderDate, return the year and the number of sales lines, earliest year first.

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.