CBSE Computer Science - Revision Tour(Solved) CBSE Guess > eBooks > Class XII > CBSE Computer Science Structure Query Language Solved Revision Tour By Mr. Ravi Kiran COMPUTER SCIENCE STRUCTURED QUERY LANGUAGE 2000 : 5. Write SQL commands for the (b) to (e) and write the outputs for (g) on thse basis of table CLUB. TABLE: CLUB
(b) To show all information about the swimming coaches in the club. Ans: Select * from Club (c) To list names of all coaches with their date of appointment (DATOFAPP) in descending order. Ans: Select Coachname from Club order by Dataofapp desc (d) To display a report, showing coachname, pay, age and bonus(15% of pay) for all coaches. Ans: Select Coachname,Pay,Age,Pay*0.15 from Club (e) To insert a new row in the CLUB table with following data: 11,”PRAKASH”,37,”SQUASH”, {25/02/98},2500,”M” Ans: Insert into Club Values (11,”PRAKASH”,37,”SQUASH”,{25/02/98}, 2500,”M”) (f) Give the output of the following SQL statements:
CBSE Computer Science Solved Revision Tour By Mr. Ravi Kiran ( [email protected] ) |
|