
SQL window functions for analysts: running totals and month-on-month change
Running totals, month-on-month change with LAG, and the difference between GROUP BY and OVER, with a dataset and tested MySQL 8 queries.
Weekday and weekend classes available
Book a free 20-minute session with a mentor
No payment on this website: confirm your schedule and payment options with our team
Novo AI Academy Insights
Short, tested articles on SQL, Excel, Power BI, Tableau, Python, data science, AI and careers in analytics. Every code example is run before it is published.

Running totals, month-on-month change with LAG, and the difference between GROUP BY and OVER, with a dataset and tested MySQL 8 queries.

AI-written SQL often runs and is still wrong. A worked example of a double-counting join, and a five-step routine to check any AI-written query.

How many projects you need, what each project write-up should show, how to organise GitHub, and what to leave out of a data analyst portfolio.
No articles in this category yet. Subscribe below to hear when new ones are published.
RSS feed · New articles are also emailed to subscribers.
Newsletter
Get new learning resources, practical guides, project ideas, and AI insights delivered to your inbox.
A few short questions and a personalized report. Or talk to a mentor for free.