580. Count Student Number in Departments

Still remember the difference between 'INNER JOIN' and 'OUTTER JOIN' in SQL?

Do you know other expressions using the 'COUNT' function besides 'COUNT(*)'?