SQL - Year wise Student Count
student is a database table containing whose create DDL is given below.
Write the SQL to list the year wise
count of the students.
(The year must be the first column in the resultset. The count of the students belonging to the specific year must be the second column in the resultset).
select year, count(*) from student group by year;
Please do comment If u have any Queries!