SQL Joins and Group Filtering | Dataford Interview Questions

Imagine a database schema with tables for Students, Courses, and Enrollments. Write a SQL query utilizing multiple JOIN operations and a GROUP BY clause to find courses with more than a specific number of students.

For this exercise, use more than 2 students as the threshold.

Output

Return one row per qualifying course.
Include course_id, course_name, and student_count.
Order by student_count descending, then course_id ascending.

Schema

students

Column	Type	Description
student_idPK	INT	Unique student identifier
student_name	VARCHAR(100)	Student's full name

courses

Column	Type	Description
course_idPK	INT	Unique course identifier
course_name	VARCHAR(150)	Course title

enrollments

Column	Type	Description
enrollment_idPK	INT	Unique enrollment identifier
student_id	INT	Referenced student identifier
course_id	INT	Referenced course identifier

Your question is SQL Joins and Group Filtering. Start with the requirements and the three 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