Question: Exercise 2 Basic SQL ( Valid for Class Participation score: 5 % of final score ) Given the following database Produce the following SQL queries:

Exercise 2 Basic SQL (Valid for Class Participation score: 5% of final score) Given the following database Produce the following SQL queries: 1. Find sids of sailors with rating below 9 who have not reserved a blue or red boat (20 Marks)2. Find sids of sailors who have reserved boats in 25/9/2020 or 26/9/2020. Use UNION. (20 Marks)3. Count the number of different Reservation bid(s).(20 Marks)4. Find the name of sailors whose rating is lower than the average rating of all the sailors. (20 Marks)5. Find sailors whose rating is higher than that of some sailor called Blackbeard. Use SOME. (20 Marks) Sailors(sid: integer, sname: string, rating: integer, age: real) Boats(bid: integer, bname: string, color: string) Reserves(sid: integer, bid: integer, day: date)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!