Untitled query #27171

SQL

use cswiki_p;

select
	count(course_id),
	case
      when courses.course_start like "2008%" then "2008"
      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"
    end as courses_per_year
    
from ep_users_per_course as users_per_course

join ep_courses as courses on users_per_course.upc_course_id=courses.course_id

group by courses_per_year
;
SQL

Checking query status...
