SQL
x
use cswiki_p;
select course_id
-- when courses.course_start like "2009%" then "2009"
-- count(courses.course_start like "2010%") as "2010",
-- count(courses.course_start like "2011%") as "2011",
-- count(courses.course_start like "2012%") as "2012",
-- count(courses.course_start like "2013%") as "2013",
-- count(courses.course_start like "2014%") as "2014",
-- count(courses.course_start like "2015%") as "2015",
-- count(courses.course_start like "2016%") as "2016",
-- count(courses.course_start like "2017%") as "2017",
-- count(courses.course_start like "2018%") as "2018"
from ep_users_per_course as users_per_course
join ep_courses as courses on users_per_course.upc_course_id=courses.course_id
where courses.course_start like "2009%"
;
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.