Your question is Course IDs With >100 Students. 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.
Antra's learning platform needs to identify courses whose total registrations exceed 100 students. The registration data is stored in batches, where each batch represents a distinct group of students for a course and term.
Write a PostgreSQL query that returns every qualifying course's name and ID.
courses to course_registration_batches using the course ID.course_id in ascending order.| Column | Type | Description |
|---|---|---|
| course_idPK | INT | Unique identifier for the course |
| course_name | VARCHAR(150) | Name of the Antra course |
| Column | Type | Description |
|---|---|---|
| batch_idPK | INT | Unique identifier for a registration batch |
| course_id | INT | Course associated with the registration batch |
| term | VARCHAR(30) | Academic term for the registration batch |
| registered_count | INT | Number of distinct students registered in the batch |