Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Tflanagan (WMF)
.
The ep_course table user list is more accurate than the other tables, but the result is an array in a field. How can I separate the field into a student_user_id column?
Toggle Highlighting
SQL
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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...