get max count joing 2 tables
by john murphy
I have 2 tables 1 STUDENT (ID, NAME , COURSE_ID)
2 COURSE(ID, NAME)
I need to get the COURSE.NAME and Count of students for the course that has the most students assigned to it in 1 select statement using Oracle 11g.