Question

City
Marks
551
Write a output for SQL queries O to (iii), which are based on the table: STUDENT
given below:
Table : STUDENT
RollNo Name
Class
DOB
Gender
Nanda
06-06-1995 M
Agra
Saurabh XII
07-05-1993 M
Mumbai
Sal
06-05-1994
Delhi
Trisla
08-08-1995
Mumbai
Store
08-10-1995
Delhi
Marisla
12-12-1994
Dubai
7
Neha
X
08-12-1995
Moscow
8
Nishant X
12-06-1995
Moscow
XIL
400
450
869
250
O SELECT COUNT(*), City FROM STUDENT GROUP BY CITY HAVING COUNT(*)>1;
(ii) SELECT MAX(DOB),MIN(DOB) FROM STUDENT;
(IT) SELECT NAME,GENDER FROM STUDENT WHERE CITY="Delhi";​

Answer 1

Answer:

char x[]="a"; is the code.

Hope this helps.