![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2021/03/SQL2-min-1.png?resize=540%2C276&ssl=1)
(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;