Your question is Running Totals of Course Enrollments. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Cengage needs a daily enrollment trend for courses delivered through MindTap. Write a PostgreSQL query that counts confirmed enrollments by day and calculates the cumulative enrollment total from August 1 through August 5, 2025.
enrollments to courses and include only courses whose product_name is MindTap.daily_enrollments and a chronological running_total.| Column | Type | Description |
|---|---|---|
| course_idPK | INTEGER | Unique course identifier |
| course_code | VARCHAR(20) | Cengage course code |
| course_title | VARCHAR(150) | Course title |
| product_name | VARCHAR(50) | Cengage delivery product |
| Column | Type | Description |
|---|---|---|
| enrollment_idPK | INTEGER | Unique enrollment event identifier |
| course_id | INTEGER | Referenced course identifier |
| enrolled_on | DATE | Date of the enrollment event |
| enrollment_status | VARCHAR(20) | Enrollment state |