i) display names of students who have grade 'C' in either game 1 or game 2 or both. ( Subject : informatics practices , CHapter - Simple queries in sql.)
Dear student,
Clearly, by looking the image we obtain the following information
Therefore, the names of students who got grade C are Sujit, Venna, Arpit.
Regards
Clearly, by looking the image we obtain the following information
Student No. | Name | Game | Grade |
11 | Sujit | skating | C |
13 | Venna | Tennis | C |
15 | Arpit | Athletics | C |
Therefore, the names of students who got grade C are Sujit, Venna, Arpit.
Regards