(a) To show all information about the swimming coaches in the club
(b) To list names of all coaches with their date of appointment (DATEOFAPP0 in descending order.
(c) To display a report, showing coachname, pay, age and bonus (15% of pay) of all the coaches.
Ans:
(a) SELECT * FROM CLUB WHERE SPORT = “Swimming”;
(b) SELECT COACHNAME FROM CLUB ORDER BY DATEOFAPP DESC;
(c) SELECT COACHNAME, PAY, AGE, (PAY*0.15) AS BONUS FROM CLUB;