USE arwiki_p; #set the language/project

​

# SELECT user_name, user_id from user WHERE user_name = 'Reem Al-Kashif'; #This user should be in all 3 courses

​

# SELECT * from ep_students WHERE student_user_id = 552387 GROUP BY student_first_course;

​

#student user table

SELECT COUNT(student_user_id) from ep_students

WHERE student_first_course = 56

GROUP BY student_first_course;

​

#course table

SELECT course_id, course_start, course_End, course_students FROM ep_courses

WHERE course_id IN (2,56,63); #IN allows you to specify multiple course IDs*/