Select Board & Class

Login
Kavya asked a question
Subject: English, asked on on 15/9/19
Tushar Gupta . asked a question
Subject: English, asked on on 4/2/12
Angel Angelina asked a question
Subject: English, asked on on 15/9/20
Musarrat Karim asked a question
Subject: English, asked on on 12/7/16
Sahil Moudgill asked a question
Subject: English, asked on on 7/2/14
prasantabiswas_teacher... & 1 other asked a question
Subject: English, asked on on 14/12/12
Aaryan Raj asked a question
Subject: English, asked on on 21/11/19
Mukesh Kumar asked a question
Subject: English, asked on on 27/1/15
Raghav asked a question
Subject: English, asked on on 27/3/12
Sakshi Pal asked a question
Subject: English, asked on on 24/7/18
Sagar asked a question
Subject: English, asked on on 24/2/15
Vanshi Bhanushali asked a question
Subject: English, asked on on 12/6/19
Owaiz asked a question
Subject: English, asked on on 6/3/14
Advika Singh asked a question
Subject: English, asked on on 27/4/20
Rama Isha Kant & 1 other asked a question
Subject: English, asked on on 21/3/13
Aaryan Raj asked a question
Subject: English, asked on on 21/11/19
lalithasri asked a question
Subject: English, asked on on 6/11/10
Adithya asked a question
Subject: English, asked on on 31/8/21
Ananya asked a question
Subject: English, asked on on 18/10/21
Deepak asked a question
Subject: English, asked on on 19/5/12
Udit Mishra asked a question
Subject: English, asked on on 31/10/18
Vineet Gaur & 1 other asked a question
Subject: English, asked on on 28/4/13
Atharva S asked a question
Subject: English, asked on on 23/10/21
Ranjeet asked a question
Subject: English, asked on on 15/6/19
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;
Upasana Dey asked a question
Subject: English, asked on on 22/11/16
Ashwin asked a question
Subject: English, asked on on 1/6/12
G.v Sankirtana asked a question
Subject: English, asked on on 27/8/18
Abhilasha Saini asked a question
Subject: English, asked on on 8/6/12
Reva Gitesh Kulkarni asked a question
Subject: English, asked on 2 weeks ago
Shubham Inshan asked a question
Subject: English, asked on on 4/7/13
Shrishti Singh asked a question
Subject: English, asked on on 26/11/19
Md Ashhad asked a question
Subject: English, asked on on 31/5/13
Shrishti Singh asked a question
Subject: English, asked on on 29/11/19
Saina Madan asked a question
Subject: English, asked on on 17/8/20
Samip Parghi asked a question
Subject: English, asked on on 28/10/20
Anushka Das asked a question
Subject: English, asked on on 17/6/12
Reva Gitesh Kulkarni asked a question
Subject: English, asked on 2 weeks ago
Yayah Ahmad asked a question
Subject: English, asked on on 3/12/17
What are you looking for?

Syllabus