Desperate and need help finishing this Assignment. Below is a link to whats been answered so far.

https://www.chegg.com/homework-help/questions-and-answers/desperate-need-help-sql-developement-pay-done-father-passed-away-last-week-got-backt-town--q28378885

Need questions 3-10

3. List the name, size, passenger capacity, and crew capacity of each ship.

4. List the names and registry of all ships with a Contemporary lifestyle.

5. List the Cruise ID, the departure date, and ship name for all cruises departing from Miami.

6. List the Cruise ID, departure date, and departure city of all cruises longer than 5 days in duration.

7. List the name and registry of all ships used in a cruise that departs from Miami. (Use the IN + subquery construct.)

8. List the name of all passengers with a reservation on a cruise that departs from Miami. (Use the IN + subquery construct.)

9. List the name of all passengers who have requested a Vegetarian diet on a cruise. Include the name of the ship in query output. (Do a join.)

10. List the names of all passengers with a reservation on a cruise that departs from Miami on 25-May-15. Include the name of the ship in the query output. (Do a join.)