Microsoft SQL Server Development for Everyone - SQL COUNT Aggregate Function

The video tutorial covers using SQL to count the number of students enrolled per course. It begins with a basic query to select data from an enrollments table and explains the need for aggregate functions to count students. The tutorial highlights the importance of using GROUP BY with aggregate functions and demonstrates how to enhance query output by including additional columns and formatting. The video concludes with a practical example of generating a report suitable for administrative purposes.

What aggregate function is used to count the number of students per course?

How does the teacher suggest modifying the query for better output presentation?