Question: Exercise 2 Basic SQL ( Valid for Class Participation score: 5 % of final score ) Given the following database Produce the following SQL queries:
Exercise Basic SQL Valid for Class Participation score: of final score Given the following database Produce the following SQL queries: Find sids of sailors with rating below who have not reserved a blue or red boat Marks Find sids of sailors who have reserved boats in or Use UNION. Marks Count the number of different Reservation bids Marks Find the name of sailors whose rating is lower than the average rating of all the sailors. Marks Find sailors whose rating is higher than that of some sailor called Blackbeard. Use SOME. Marks Sailorssid: integer, sname: string, rating: integer, age: real Boatsbid: integer, bname: string, color: string Reservessid: integer, bid: integer, day: date
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
