Table "Sports" is shown below. Write statements in SQL for (i) to (iv) and output for (v) and (vi)
Table: Sports
StudentId |
Name |
Gender |
DateAdmit |
Game |
Fee |
S101 |
Anisha Thakur |
F |
2015-09-12 |
Badminton |
34000 |
S102 |
tipti Saluja |
F |
2015-08-12 |
Lawn Tennis |
50000 |
S103 |
Divya Sharma |
F |
2015-11-01 |
Badminton |
55000 |
S104 |
FauziaZar |
F |
2015-12-09 |
Lawn Tennis |
60000 |
S105 |
Richard Desouza |
M |
2015-12-10 |
Cricket |
50000 |
(i) To display all details of Students who have enrolled for 'Badminton' coaching.
(ii) To display names of girl students who have enrolled for 'Lawn Tennis'.
(iii) To display names of students, game enrolled, fee in ascending order of fee being paid by them.
(iv) To game name and number of students enrolled in each game.
(v) SELECT Name, Game, Fee FROM Sports WHERE Fee BETWEEN 50000 AND 60000.
(vi) SELECT Name, DateAdmit FROM Sports WHERE DateAdmit < '2015-12-09'.