SQL
x
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*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.