find the names of all students who have taken at least one elec. eng. course.

by Corbin Herzog Sr. 7 min read

How to find the ID of students who take every course?

Assuming course table contains all the courses a student can take, you can group by the id column in the results table and check if the count is equal to the row count in course table.

How to group courses in a course table?

Assuming course table contains all the courses a student can take, you can group by the id column in the results table and check if the count is equal to the row count in course table.

image