질문 내용
select c1.course_id, count(*) from checkins c1
inner join courses c2 on c1.course_id = c2.course_id
group by c1.course_id
꼭 as cnt 붙여야 하나요?