select
	course_id,
    course_name,
    count(distinct user_id)
from attend_tb
join course_tb
	using (course_id)
where in_datetime <= substring(course_datetime, 1, 15) and out_datetime >= substring(course_datetime, 1, 15)
group by course_id, course_name
order by course_id;