This query is marked as a draft This query has been published by Tflanagan (WMF).

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.

Checking query status...