RDBMS Type: MySQL
Returns a count of the number of non-NULL values of expr in the rows
retrieved by a SELECT statement. The result is a BIGINT value.
If there are no matching rows, COUNT() returns 0.
This function executes as a window function if over_clause is present.
over_clause is as described in
mysql> SELECT student.student_name,COUNT(*)
GROUP BY student_name;