22
Consider the following STUDENT Table and answer the SQL queries based on it.
Student No Class Name Game Gradel SUPO
Grade 2
10
7 Sameer Cricket
B. Photography
8 Sujit Tennis
A Gardening C
12
7 Kamal Swimming B Photography
13
Veena Tennis
C Cooking A
14
9 Archana Basket
A Literature
Ball
15
10 Arpit Cricket
A Gardening C
Display the names of the students who are getting a grade 'C' in either GAME
or SUPW.
1
Display the different games offered in the school.
TI
Display the SUPW taken up by the students, whose name starts with 'A'
III
Display all the details of student table.
IV
V
Display the list of students of class 7.
Share
Answer:
22
Consider the following STUDENT Table and answer the SQL queries based on it.
Student No Class Name Game Gradel SUPO
Grade 2
10
7 Sameer Cricket
B. Photography
8 Sujit Tennis
A Gardening C
12
7 Kamal Swimming B Photography
13
Veena Tennis
C Cooking A
14
9 Archana Basket
A Literature
Ball
15
10 Arpit Cricket
A Gardening C
Display the names of the students who are getting a grade 'C' in either GAME
or SUPW.
1
Display the different games offered in the school.
TI
Display the SUPW taken up by the students, whose name starts with 'A'
III
Display all the details of student table.
IV
V
Display the list of students of class 7.