Hello Everyone,
I am writing a query that retrieves popular course Names based on the number of enrollments to the course.. let me know where i am going wrong..
select c.fullname,count(e.courseid) from mdl_course c,mdl_enrol e where c.id=e.id group by e.courseid,c.fullname;