SQL interview question: Cumulative Sum Over Time

Cumulative Student Enrollment Growth

The growth team wants to visualize total cumulative enrollments over time.

Calculate the running total of new student enrollments by month.

Return enrollment_month (YYYY-MM format), new_students (count per month), and cumulative_total (running sum). Use SUM() OVER.

Skills: window function SUM() OVER with running total

Tables

students 25 rows
  • student_id integer PK
  • name text
  • email text
  • grade_level integer
  • gpa real
  • enrollment_date text
student_idnameemailgrade_levelgpaenrollment_date
1Alice Johnson[email protected]123.92024-09-01
2Bob Smith[email protected]123.72024-09-01
3Carol Williams[email protected]123.82024-09-01
About the school sample database

Practice on your iPhone

Query Dojo for iPhone has 85 interview questions, timed mock interviews and a tile builder, so you can write queries without a keyboard.

Get the app

Keep going