Page 3 :
5. Write SQL commands for the following on the basis of given table CLUB., , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ICBSE OD any,, Table ; CLUB, COACH_ID | COACHNAME | AGE sports _|(aToFAPP)| pay | sex, 7 KUKREJA | 35 | KARATE 27/03/1996 | 1000 M, 2 RAVINA | 34 | KARATE 20/01/1998 | 1200 F, 3. KARAN 34 | SQUASH 19/02/1998 | 2000 M, 4. TARUN 33 | BASKETBALL | 01/01/1998 | 1500 M, 5, ZUBIN 36 | SWIMMING | 12/01/1998 | 750 M, 6. KETAKI 36 | SWIMMING | 24/02/1998 | 800 F, 7. ANKITA 39 | SQUASH 20/02/1998 | 2200 F, 6. ZAREEN | 37 | KARATE 22/02/1998 | 1100 F, 9. KUSH | 41 | SWIMMING | 13/01/1998 | 900 M, 10, SHAILYA | 37 | BASKETBALL | 19/02/1998 | 1700 M, , , , , , , , {a) To show all information about the swimming coaches in the club., , (b) To list names of all coaches with their date of appointment (DATOFAPP) in descending order., (0) To display a report, showing coachname, pay, age and bonus (15% of pay) for all the coaches., , Cc) Seve ct, , Conchmeme | AGE , Pay, , ‘, , a) Sevect * From Cive, WHERE SPORTS = ‘Swimming |, b) Sevect CoacHNamG,, , DATOFAPP? FRom CLY®, ORDER &Y Datof APP, Desc;, , ) >, Pay ~ O-IS an‘ BONUS from Clus;
