Write SQL commands for the following on the basis of given table STUDENT :

Table : STUDENT

StudentNo.	Class	Name	GAME	Grade1	SUPW	Grade2
10	7	Sameer	Cricket	B	Photography	A
11	8	Sujit	Tennis	A	Gardening	C
12	7	Kamal	Swimming	B	Photography	B
13	7	Veena	Tennis	C	Cooking	A
14	9	Archana	Basket Ball	A	Literature	A
15	10	Arpit	Cricket	A	Gardening	C

1. Display the names of the students who are getting a grade 'C' in either GAME or SUPW.
2. Display the different games offered in the school.
3. Display the SUPW taken up by the students, whose name starts with 'A'.

1.

SELECT Name
FROM STUDENT
WHERE Grade1 = 'C' OR Grade2 = 'C' ;

Output

+-------+
| Name  |
+-------+
| Sujit |
| Veena |
| Arpit |
+-------+

2.

SELECT DISTINCT GAME
FROM STUDENT ;

Output

+-------------+
| GAME        |
+-------------+
| Cricket     |
| Tennis      |
| Swimming    |
| Basket Ball |
+-------------+

3.

SELECT SUPW
FROM STUDENT
WHERE Name LIKE 'A%' ;

Output

+------------+
| SUPW       |
+------------+
| Literature |
| Gardening  |
+------------+