SQL interview question: DELETE Rows With a Condition
Academic Fresh Start
The registrar's new "fresh start" policy erases all C-range grades (C+, C, and C-) so students can retake those courses.
Write a single DELETE statement removing every enrollment whose grade starts with 'C'.
Note: Your change is verified automatically and rolled back afterwards.
This challenge changes data. Your statement runs on a private copy of the database, then we check the resulting table.
Tables
enrollments 47 rows
- enrollment_id integer PK
- student_id integer → students
- course_id integer → courses
- semester text
- grade text
| enrollment_id | student_id | course_id | semester | grade |
|---|---|---|---|---|
| 1 | 1 | 1 | Fall 2024 | A |
| 2 | 1 | 3 | Fall 2024 | A |
| 3 | 1 | 5 | Fall 2024 | A- |