Question

Consider the following table Schooldata:

Table: Schooldata
Admno	Name	Grade	Club	Marks	Gender
20150001	Sargam Singh	12	STEM	86	Male
20140212	Alok Kumar	10	SPACE	75	Male
20090234	Mohit Gaur	11	SPACE	84	Male
20130216	Romil Malik	10	READER	91	Male
20190227	Tanvi Batra	11	STEM	70	Female
20120200	Nomita Ranjan	12	STEM	64	Female

Write SQL queries for the following:

(i) Display the average Marks secured by each Gender.

(ii) Display the minimum Marks secured by the students of Grade 10.

(iii) Display the total number of students in each Club where number of students are more than 1.
                                     OR

(iii) Display the maximum and minimum marks secured by each gender.

Answer 1

(i) select gender, avg(marks) from school data group by gender;

(ii) select min(marks) from school data where grade = 10;

(iii) select club, count(*) from school data group by club having count(*)>1;

                                OR

(iii) select gender, min(marks), max(marks) from school data group by gender;