Create a query of renters not qualified to rent, list who rented boat unique ID, Renter name, Renter Telephone Number and Renter Email address. Create a query where you can see all boats available for rent that are longer than 30 feet, include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location (where boat is parked for pickup). Create a query where you can see all powerboats available for rent of any length include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location. Create a query where you can see all the boats available at a Marina Name = ‘Star Island Yacht Club’ or a name of a marina in your data. Include Boat Name, BoatT ype and Cost to rent the boat per day. Create a query where you can see all boats available at a Marina Name = “Star Island Yacht Club”, include Boat Name, Boat Type and Cost to Rent per Day for only boats that have a Cost to Rent per Day that is more than $400. Create an update query that lowers the daily rental rate of sailboat rentals by 10%. Note: show me select * from boat of values and contents of data in boat table after you run this update. I should have the before from the beginning of the assignment. Search for boats for rent under $200 per day, show Boat Unique Identifier, Boat Type, Boat Length, Price per Day to rent the boat and Location. Create a query that shows the rentals that had different pickup and different drop off location, show Boat Unique identifier, Renter unique identifier, Start Date, End Date, Pickup Location and Drop Off Location and drop off fee of the Marina Drop Off Location. Create a query that shows Renter unique identifier, Renter name, boat unique identifier, boat name, startdate, enddate of a rental and number of days rented (name column duration of rental). This will ensure you are counting your days right for some of the following queries. 10. Create a query that shows rentals longer than 1 day, this should list Boat Owner Unique Identifier, Boat Name, Boat Length, pickup location (Unique Identifier and Name of pickup location) and # of days rented. 11. Same as above, show rentals longer than a day, show Boat type, start date of rental, end date of rental and marina name of pickup and number days rented. 12. Create a query that shows how much each boat earned in Rental income. This is a calculated query. You need to compute number of days boats were rented and multiply by price of rental per day. Output columns should be as follows: Boat Name Income 13. Create a query that shows how much each boat earned in Owner Rental Income (what is the owners percentage). This query should have the following output columns. Boat Name Owner Rental Income Now show both of the above to appear in one query. The following columns: Boat Name Boat Rental Income Owner Rental Income Create a listing of Owners and Boats they have for rent on the app, include Owner ID, Owner Name and Boat Name, price per day, owner rent percent, Boat Type and Boat Location. Create a listing of what boat had the most rentals include boat name and number of rentals. Include boat name and number of rentals. You can do this with descending order The columns for this question is, hint, you need to count, not sum. Its okay if you don't just have top one, you can have all of them. Boat Name # of Rentals 17. Now add number of days rented to the above so it shows BoatName, number of rentals and number of days rented? BoatName Number of Rentals NumberOfDaysRented

Create a query of renters not qualified to rent, list who rented boat unique ID, Renter name, Renter Telephone Number and Renter Email address. Create a query where you can see all boats available for rent that are longer than 30 feet, include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location (where boat is parked for pickup). Create a query where you can see all powerboats available for rent of any length include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location. Create a query where you can see all the boats available at a Marina Name = ‘Star Island Yacht Club’ or a name of a marina in your data. Include Boat Name, BoatT ype and Cost to rent the boat per day. Create a query where you can see all boats available at a Marina Name = “Star Island Yacht Club”, include Boat Name, Boat Type and Cost to Rent per Day for only boats that have a Cost to Rent per Day that is more than $400. Create an update query that lowers the daily rental rate of sailboat rentals by 10%. Note: show me select * from boat of values and contents of data in boat table after you run this update. I should have the before from the beginning of the assignment. Search for boats for rent under $200 per day, show Boat Unique Identifier, Boat Type, Boat Length, Price per Day to rent the boat and Location. Create a query that shows the rentals that had different pickup and different drop off location, show Boat Unique identifier, Renter unique identifier, Start Date, End Date, Pickup Location and Drop Off Location and drop off fee of the Marina Drop Off Location. Create a query that shows Renter unique identifier, Renter name, boat unique identifier, boat name, startdate, enddate of a rental and number of days rented (name column duration of rental). This will ensure you are counting your days right for some of the following queries. 10. Create a query that shows rentals longer than 1 day, this should list Boat Owner Unique Identifier, Boat Name, Boat Length, pickup location (Unique Identifier and Name of pickup location) and # of days rented. 11. Same as above, show rentals longer than a day, show Boat type, start date of rental, end date of rental and marina name of pickup and number days rented. 12. Create a query that shows how much each boat earned in Rental income. This is a calculated query. You need to compute number of days boats were rented and multiply by price of rental per day. Output columns should be as follows: Boat Name Income 13. Create a query that shows how much each boat earned in Owner Rental Income (what is the owners percentage). This query should have the following output columns. Boat Name Owner Rental Income Now show both of the above to appear in one query. The following columns: Boat Name Boat Rental Income Owner Rental Income Create a listing of Owners and Boats they have for rent on the app, include Owner ID, Owner Name and Boat Name, price per day, owner rent percent, Boat Type and Boat Location. Create a listing of what boat had the most rentals include boat name and number of rentals. Include boat name and number of rentals. You can do this with descending order The columns for this question is, hint, you need to count, not sum. Its okay if you don't just have top one, you can have all of them. Boat Name # of Rentals 17. Now add number of days rented to the above so it shows BoatName, number of rentals and number of days rented? BoatName Number of Rentals NumberOfDaysRented

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...

See similar textbooks

Related questions

Question

Create a query of renters not qualified to rent, list who rented boat unique ID, Renter name, Renter Telephone Number and Renter Email address.
Create a query where you can see all boats available for rent that are longer than 30 feet, include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location (where boat is parked for pickup).
Create a query where you can see all powerboats available for rent of any length include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location.
Create a query where you can see all the boats available at a Marina Name = ‘Star Island Yacht Club’ or a name of a marina in your data. Include Boat Name, BoatT ype and Cost to rent the boat per day.
Create a query where you can see all boats available at a Marina Name = “Star Island Yacht Club”, include Boat Name, Boat Type and Cost to Rent per Day for only boats that have a Cost to Rent per Day that is more than $400.
Create an update query that lowers the daily rental rate of sailboat rentals by 10%.

Note: show me select * from boat of values and contents of data in boat table after you run this update. I should have the before from the beginning of the assignment.

Search for boats for rent under $200 per day, show Boat Unique Identifier, Boat Type, Boat Length, Price per Day to rent the boat and Location.
Create a query that shows the rentals that had different pickup and different drop off location, show Boat Unique identifier, Renter unique identifier, Start Date, End Date, Pickup Location and Drop Off Location and drop off fee of the Marina Drop Off Location.
Create a query that shows Renter unique identifier, Renter name, boat unique identifier, boat name, startdate, enddate of a rental and number of days rented (name column duration of rental). This will ensure you are counting your days right for some of the following queries.

10. Create a query that shows rentals longer than 1 day, this should list Boat Owner Unique Identifier, Boat Name, Boat Length, pickup location (Unique Identifier and Name of pickup location) and # of days rented.

11. Same as above, show rentals longer than a day, show Boat type, start date of rental, end date of rental and marina name of pickup and number days rented.

12. Create a query that shows how much each boat earned in Rental income. This is a calculated query. You need to compute number of days boats were rented and multiply by price of rental per day. Output columns should be as follows:

Boat Name Income

13. Create a query that shows how much each boat earned in Owner Rental Income (what is the owners percentage).

This query should have the following output columns.

Boat Name Owner Rental Income

Now show both of the above to appear in one query. The following columns:

Boat Name Boat Rental Income Owner Rental Income

Create a listing of Owners and Boats they have for rent on the app, include Owner ID, Owner Name and Boat Name, price per day, owner rent percent, Boat Type and Boat Location.
Create a listing of what boat had the most rentals include boat name and number of rentals. Include boat name and number of rentals. You can do this with descending order
- Boat Name # of Rentals 17. Now add number of days rented to the above so it shows BoatName, number of rentals and number of days rented?

BoatName Number of Rentals NumberOfDaysRented

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.