SELECT Course_Name, (

SELECT count( * )
FROM `enrolled`
GROUP BY Course_Uid
)
FROM course
WHERE Course_Uid
IN (

SELECT Course_Uid
FROM enrolled
GROUP BY Course_Uid
);

select a.course_uid,a.course_name,count(b.student_uid) cout
from course a,enrolled b 
where a.course_uid=b.course_uid
group by a.course_uid;