Question

19. Write SQL command for the following on the basis of given ta
Table: STUDENT
StudentNo Class Name
GAME
Grade1 SUPW
Grade
10
7
Sameer
Cricket
B
Photography A
11
8
Sujit
Tennis
А
Gardening
C
12
7
Kamal
Swimming B
Photography B
13
7
Veena
Tennis
C
Cooking
9
Archana Basketball
Literature
15
Arpal
Cricket
A
Gardening
(A) Display the names of students who are getting a grade in the
GAME or SUPW
(8) Display different games offered in the school
c) Display the SUPW taken up by the students whose na​

Answer 1

ExplanatWrite SQL command for the following on the basis of given ta

Table: STUDENT

StudentNo Class Name

GAME

Grade1 SUPW

Grade

10

11

8

Sujit

Tennis

А

Gardening

C

12

7

Kamal

Swimming B

Photography B

13

7

Veena

Tennis

C

Cooking

9

Archana Basketball

Literature

15

Arpal

Cricket

A

Gardening

(A) Display the names of students who are getting a grade in the

GAME or SUPW

(8) Display different games offered in the school

c) Display the SUPW taken up by the students whose na