Table "Sports" is shown below. Write statements in SQL for (i) to (iv) and output for (v) and (vi)
|S102||tipti Saluja||F||2015-08-12||Lawn Tennis||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'.