Write SQL commands for the following on the basis of given table Club.

(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;

error: Content is protected !!