Can you please help me get sql query for below output from the input provided :

You might want to try something like this:

select number of classes, student, count(*) as Count
From tablename
group by number of classes, student

Good luck!

SELECT NO OF CLASSES,STUDENT,COUNT(*) AS COUNT
FROM TABLE
GROUP BY NO OF CLASSES,STUDENT
ORDER BY STUDENT ASC;

SELECT [No of classes], Student, COUNT(*) AS Count
FROM TABLE
GROUP BY [No of classes], Student
ORDER BY Student ASC, [No of classes] DESC;