Skip to main content

Year-over-Year Growth & Retention Analysis

Learn Year-over-Year Growth & Retention Analysis (Advanced SQL Interview Problems, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Year-over-year growth compares each year with the previous one: (current - previous) / previous. LAG() fetches the previous row.

More lessons in Advanced SQL Interview Problems