Can you show me all the course ids and enrollments?
SELECT T1.cID, COUNT ( * )  FROM COURSE AS T1 JOIN ENROLLED_IN AS T2 ON T1.CID   =   T2.CID GROUP BY T2.CID
show all course ids and enrollments refers to selecting cID from COURSE table and counting all entries in ENROLLED_IN table grouped by cID;