Question

Predict the output of the following query based on the table Sports given below:

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

SELECT UCASE(TRIM(SName)) FROM Sports WHERE Sid=5;

Answer 1

Output: BADMINTON

Explanation:

When the Sid field in the Sports table equals 5, the supplied SQL query chooses the trimmed, uppercase SName column for that entry.