Question: 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

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 (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

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!

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...

Using the NBA schema that you have already created answer the questions that follow: team team ID tnamc rank city championships INTEGER INTEGER VARCHAR(15) INTEGER VARCHAR(20) team player_arena...

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...

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...

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...

POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED B) Write and run the following queries (50 points) 1. Print the player_ids and names of players of Point guards drafted after the year 2000 2. Print the...

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...

Question Consider the Sailors - Boats - Reserves DB described in the text. s ( sid , sname, rating, age ) b ( bid , bname, color ) r ( sid , bid, date ) Write each of the following queries in SQL . 1...

Consider the following relational schema: Department(deptid, dname, location) Student(snum, sname, deptid, age) Faculty (fid, fname, deptid) Class(cname, deptid meets_at, room, faculty)...

T merges into P solely in exchange for P voting Stock (and the debt assumptions). B, however, dissents under state law procedure for objecting shareholders. B's T stock is purchased by T under an...

Two samples are irradiated with fast neutrons in the same vial. The K-Ar age of one of them (the monitor) is known. It is observed that some of the 39K of the samples is transformed into 39 Ar. Using...

Identity the status of pins : ( S 1 , S 0 ) , ( IO / M , RD , WR ) situation is microprocessor wants to write data from memory

Fnhres for site of Fixed Ratet a. What was the book value of the equipment at December 31 the end of the fourth year? x 7 thaibur thin Book value is the initial cost of the ficed asset minus the...

4. What degree of alignment is there between the company values and the areas assessed?

5. How do you train assessors and what level of on-going training occurs to ensure rater consistency?

2. As Erica Liu, what analyses would you run to assess the financial performance of the RD membership program?