Write a select statement that will display student id, student last name and the
number of courses a student has been enrolled. You will need to join two table, use a
COUNT aggregate and a GROUP BY clause in your SELECT statement.
this is something i found on internet, im not a student and not a uni student who is willing to do his assignment, im just learning it myself... alli did is
SELECT s_id, s_last, Count (max_enrl) From UC_Student, UC_Enrollment Where UC_Student = UC_Enrollemnt Group by s_id, s_last
but its not giving me the correct output, what should I do ....