What is the meaning of the following query?
Select EnrollmentDate, Count(*) AS StudentCount
From TableName
GROUPBY EnrollmentDate

Answer:

The AS clause holds the column name that you want to give.
Hence in the result, the column name for the count will be StudentCount whereas if you dont specify the AS clause then in the result it shows No column name because this column(Count) doe not exist in your database.