Question

Write a output for SQL queries (i) to (iii), which are based on the table: STUDENT given below:

Table : STUDENT

Roll No	Name	Class	DOB	Gender	City	Marks
1	Nanda	X	06 - 06 - 1995	M	Agra	551
2	Saurabh	XII	07-05-1993	M	Mumbai	462
3	Sanal	XI	06 - 05 - 1994	F	Delhi	400
4	Trisla	XII	08 - 08 - 1995	F	Mumbai	450
5	Store	XII	08 - -10 - 1995	M	Delhi	369
6	Marisla	XI	12 - 12 - 1995	F	Dubai	250
7	Neha	X	08 - 12 - 1995	F	Moscow	377
8	Nishant	X	12 - 06 - 1995	M	Moscow	489

(i)  SELECT COUNT(*), City FROM STUDENT GROUP BY CITY HAVING COUNT(*)>1;

(ii)  SELECT MAX(DOB),MIN(DOB) FROM STUDENT;

(iii)  SELECT NAME,GENDER FROM STUDENT WHERE CITY=”Delhi”; 

Answer 1

(i)

COUNT(*)	City
2	Mumbai
2	Delhi
2	Moscow

(ii)

MAX(DOB)	MIN(DOB)
08-12-1995	07-05-1993

(iii)

NAME	GENDER
Sanal	F
Store	M