Q. 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 (DATOFAPP) in descending order.
(c) To display a report, showing coachname, pay, age and bonus (15% of pay) for all the coaches.
Answer =
(a)
Select * from CLUB
Where sports = “SWIMMING”;
(b)
select coachname, datofapp from CLUB
Order by datofapp DESC;
(c) select coachname , pay , age , pay * 0.15 as Bonus from CLUB ;
didnt got MYSQL table
ReplyDeleteWe have already uploaded table in form of photo. So it take some time to show on your display.
DeleteVery helpful!
ReplyDelete😁
Delete: )
DeleteThankyou : )
ReplyDeletecan you also tell how to create this type of tables in sql
ReplyDeleteYes video link https://www.youtube.com/watch?v=ROfSrc3AuF8 and Notes Link :- https://www.pathwalla.com/2020/08/mysql-best-notes-notes-sumita-arora.html
DeleteTo list names of all coaches with their date of appointment (DATOFAPP) in descending order. (qstin 2 ) they have asked with their date of appointments doesnt it means we should show that too
ReplyDeleteOk, I have corrected it.
Deletecan you give the output table too??
ReplyDeleteSorry, but we will definitely try in future.
DeleteSelect count(distinct sports) from club;
ReplyDelete???
DeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )