Informatics Practices > Database Query using SQL > Querying And Grouping

Raghav, who works as a database designer, has created a table

as shown below:

StudentID  		Name  		AdmissionDate  		Marks  		City
101 		Aarav Sharma 		2022-04-01 		85 		Delhi
102 		Priya Iyer		2021-05-15 		78 		Mumbai
103 		Rohan Verma 		2020-06-10 		92 		Bangalore
104 		Simran Patel 		2022-03-20 		88 		Delhi
105 		Karan Yadav 		2021-08-05 		75 		Mumbai

Write suitable SQL queries for the following:

I. Show the Name and City of the students, both in uppercase, sorted alphabetically by Name.

II. Display the Student ID along with the name of the month in which the student was admitted.

III. Calculate and display the average marks obtained by students.

IV. Show the names of the cities and the number of students residing in each city.