Question

Consider the given table and write the following queries in MySQL:

Table : Sports

Sid	SName	Fees	DateofPlay	CoachId
1	Karate	1200	2024-08-24	S1
2	Football	1800	2024-09-13	S2
3	Cricket	1500	2024-06-14	S3
4	Lawn Tennis	2500	2024-09-25	S4
5	Badminton	1800	2024-10-20	S5

1. To display Sid and name of those sports which are to be played in the month of September.
2. To display all Sports names in lower case.
3. To display last two characters of all sports names whose fees is less than 1500.

Answer 1

1. SELECT Sid, SName FROM Sports WHERE MONTH(DateofPlay)=9;
2. SELECT LCASE(SName) FROM Sports;
3. SELECT RIGHT(SName, 2) FROM Sports WHERE Fees< 1500;