Question

8. Write SQL queries for (a) to (d) and find outputs for SQL queries (e) and (F), which are based on the tables. Each query carries 1 mark and each output 12 mark SPORTS Sportsname Participants PrizeMoney Scheduledate Scode Carram 5000 2012-01-23 12000 Badminton Table Tennis 102 103 Chess 105 108 Lawn Tennis Ccode 2011-12-12 2012-02-14 8000 2012-01-01 9000 2012-03-19 25000 COACH Name Ravi Mohan Sameer Scode 101 108 101 a)To display scode, the number of coaches for each scode from the table coach and display scode in descending order. b)To display details of those sports and coachname which are having PrizeMoney more than 9000 and coachname ends with 'n' c) To display the contents of the sports table with their coachname whose schedule date is in the year 2019. d)Increase the Participants by 6 for the sports carom, chess and badminton e) SELECT Sportsname, Name FROM SPORTS, COACH where prizemoney - 5000; ()SELECT SUM(PrizeMoney) FROM SPORTS WHERE sportsname in ('Badminton', carrom');

Answer 1

Answer:

10000000000000000000000000000000

Answer 2

Answer:

wrong questions good day