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 |