Consider the given table and answer the queries that follow:
Table - Sports
StudentNo Class Name Game1 Grade1 Game2 Grade2
10 7 Sammer Cricket B Swimming A
11 8 Sujit Tennis A Skating C
12 7 Kamal Swimming B Football B
13 7 Venna Tennis C Tennis A
14 9 Archana Basketball A Cricket A
15 10 Arpit Cricket A Athletics C
(a) Display the names of the students who have grade A in either Game1 or Game2 or both.
(b) Display the number of students having game -Cricket.
(c) Display the names of students who have same game for both Game1 and Game2.
(d) Display the games taken by the students whose name starts with A.
(e) Display the student names along with game options 1 and 2 for classes 6-8.
(f) Give the output of the following sql statements.
(i) SELECT COUNT(*) FROM SPORTS.
(ii) SELECT DISTINCT Class FROM SPORTS.
(iii) SELECT MAX(Class) FROM STUDENT;
(iv) SELECT COUNT(*) FROM SPORTS GROUP BY Game1;
Dear student,
(a) Sammer, Sujit, Venna, Archana and Arpit.
(b) 3 students
(c) Venna
(d) Basketball, Cricket and Athletics.
For remaining queries, we request you to post them in seperate threads for speedy assistance from our experts.
Regards.
(a) Sammer, Sujit, Venna, Archana and Arpit.
(b) 3 students
(c) Venna
(d) Basketball, Cricket and Athletics.
For remaining queries, we request you to post them in seperate threads for speedy assistance from our experts.
Regards.