Course IDs With >100 Students | Dataford Interview Questions

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.

Requirements

Join courses to course_registration_batches using the course ID.
Sum the registered students across all batches for each course.
Return only courses with more than 100 registered students.
Sort the output by course_id in ascending order.

Schema

courses

Column	Type	Description
course_idPK	INT	Unique identifier for the course
course_name	VARCHAR(150)	Name of the Antra course

course_registration_batches

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

Your question is Course IDs With >100 Students. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem