Question: Write and run the following SQL queries. Do not show duplicates: 1. Print the names of sailors who have reserved at least two boats 2.

Write and run the following SQL queries. Do not show duplicates:

1. Print the names of sailors who have reserved at least two boats

2. Print the names of sailors whose rating is within (inclusive) 5 and 8 and have reserved more than two boats

3. Find the average age of sailors who have a rating greater than 7 and have reserved a boat named Clipper or Interlake

4. Find the age of the oldest sailor for each rating level that has reserved a red boat

5. Find the sailors whose rating is worse than some sailor named Andy

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 Databases Questions!

Write and run the following queries. Do not show duplicates 1. Print the names of sailors who have reserved at least two boats 2. Print the names of sailors whose rating is within (inclusive) 5 and 8...

Write and run the following queries. Do not show duplicates (50 points) 1. Print the names of sailors who have reserved at least two boats 2. Print the names of sailors whose rating is within...

Relational Algebra Expression Create Database, Table and Use SQL Server Managament Studio to write code on New Query for each question Cho luoc do quan h gm cc quan h - Sailors(sid: integer, sname:...

Relational Algebra Expression Create Database, Table and Use SQL Server Managament Studio to write code on New Query for each question ( 6-7-8-9-10 ) Cho luoc do quan h gm cc quan h - Sailors(sid:...

This is for Oracle SQL Plus. Please answer the following question. Below is the code related to the tables Write and run the following queries. Do not show duplicates (50 points) 1. Print the names...

SQL plus statements based on this schema: SET ECHO ON -- Drop the tables if they are already there. -- OK to get an Oracle error if the table(s) not found (if running script for the first time) drop...

Solve all 5. Consider the predicates: C(x): "x is in the class." M(x): "x is a computer science major." Express each of the following statements using these predicates, quantifiers, and logical...

Write the following queries i SQL statements. The query answers must not contain duplicates, but you should use the SQL keyword DISTINCT only when necessary. When your SOL query statement is not...

Oracle SQL Plus: Please answer the following question, Below is the the code and info related to the tables Write and run the following queries. Do not show duplicates A. Print the points and name of...

Business law Note 1, we assume 1K = 1000, IM = 1,090,000, 1G = 1,000,000,000, 1Byte = 8 bits Note 2, Is = 1,000 ms = 1,000,000us 1. (20 points) We are sending a MP3 file of 1,000,000 bits from a...

Question 5: To verify the existence of Yu2 in your solution, one should first form a white precipitate by addition of NaCl. Next, the precipitate should dissolve with the addition of NaOH. Using...

At August 31, the end of the first month of operations, the usual adjusting entry transferring prepaid insurance expired to an expense account is omitted. Which items will be incorrectly stated,...

As an Advisor, you are required to only recommend investment solutions to your clients that are: Discussed during Discovery Going to increase in value Suitable Responsible

Question 1 9 ( 3 points ) The widest range of tort liability arises in the area of: negligence. absolute liability. violation of statute. assumption of risk.

2. Why has the conflict escalated?

1. What might have led to the misinformation?

1. Divide the class into small work groups to write a policy on cell phone usage while attending staff meetings.