Question

Write query based upon item table given.

Students

Adno	Name	Average	Sex	Scode
501	R.Jain	98	M	111
545	Kavita	73	F	333
705	K.Rashika	85	F	111
754	Rahul Goel	60	M	444
892	Sahil Jain	78	M	333
935	Rohan Saini	85	M	222
955	Anjali	64	F	444
983	Sneha Aggarwal	80	F	222

Display number of students in each scode.

Answer 1

SELECT Scode, COUNT(*)
FROM Students
GROUP BY Scode;