(i) To display all details of Students who have enrolled for 'Badminton' coaching.

Question

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'.

Answer 1

(i) Select * From Sports Where Game like 'Badminton'.

(ii) Select Name from Sports where Gender =  'F' and Game = 'Lawn Tennis'.

(iii) Select Name, Game, Fee From Sports Order By Fee.

(iv) Select Game, Count (Studentld) from Group By Game.

(v)

Name	Game	Fee
Tipti Saluja	Lawn Tennis	50000
Divya Sharma	Badminton	55000
Fauzia Zar	Lawn Tennis	60000
Richard Desouza	Cricket	50000

(vi)   Name                        DateAdmit

       Tripti Saluja                 2015-08-15