Question: please answer all questions. This section covers the practical implementation of a database schema using DDL and SQL queries (50 points). .Login in to the

please answer all questions.

please answer all questions. This section covers the practical implementation of a

This section covers the practical implementation of a database schema using DDL and SQL queries (50 points). .Login in to the Linux Oracle server and access the database using sqlplus (refer to Oradle Linux Server Instructions) .Display the SQL commands using: SET ECHO ON Create your homework submission log file using: SPOOL 3-FirstLastName-Lab.txt command To terminate log file use: SPOOL OFF command Using the Sailors schema (sailors.sql)- run this script file if you have not already done so and answer the questions that follow: 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 greatethan 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!