| use cswiki_p;
select count(distinct course_id) as courses_2017
from... |
5 years ago |
| use cswiki_p;
select (count distinct course_id) as courses_2017
from... |
5 years ago |
| use cswiki_p;
select distinct course_id, course_title
from... |
5 years ago |
| use cswiki_p;
select course_id, course_title
from ep_users_per_course as... |
5 years ago |
| use cswiki_p;
select course_id
from ep_users_per_course as... |
5 years ago |
| use cswiki_p;
select course_id
-- when courses.course_start like... |
5 years ago |
| use cswiki_p;
select
count(course_id)
-- when courses.course_start... |
5 years ago |
| use cswiki_p;
select
count(course_id)
-- when courses.course_start... |
5 years ago |
| use cswiki_p;
select
count(courses.course_start like "2008%") as "2008"
... |
5 years ago |
| use cswiki_p;
select
count(course_id),
case
when... |
5 years ago |
| use cswiki_p;
select
count(course_id),
case
when... |
5 years ago |
| use cswiki_p;
select
count(courses.course_start like "2008%") as... |
5 years ago |
| use cswiki_p;
select
count(courses.course_start like "2008%") as... |
5 years ago |
| use cswiki_p;
select distinct
upc_course_id,
course_title,
... |
5 years ago |
| use cswiki_p;
select distinct upc_course_id, course_title
from... |
5 years ago |
| use cswiki_p;
select distinct upc_course_id, course_title
from... |
5 years ago |
| use cswiki_p;
select distinct upc_course_id, course_title
from... |
5 years ago |
| use cswiki_p;
select distinct upc_course_id, upc_course_title from... |
5 years ago |
| use cswiki_p;
select distinct upc_course_id, upc_course_name from... |
5 years ago |
| use cswiki_p;
select distinct upc_course_id from ep_users_per_course; |
5 years ago |
| use cswiki_p;
select distinct course_id from ep_users_per_course; |
5 years ago |
