/* 8. List the date, departure time, and site name for each tour with more than three participants.*/

/* 17. For each site, list the sites at the same skill level that have lower base cost. The output should be where cost 1

/* 18. For each site area, list the site name a/* 21. List the departure date and site name of tours that either have more than seven participants or have a total of more than $230. in reservation participant cost. Use a UNION construct.*/

/* 19. List the departure date and time for all tours whose participants are NOT from Nebraska (state code = NE). Use a NOT EXISTS construct.*/

/* 21. List the departure date and site name of tours that either have more than seven participants or have a total of more than $230. in reservation participant cost. Use a UNION construct.*/

/* 31. For each site, list the tour visiting that site with the largest number of participants.*/

/* 32. List the name of each site, the base cost, and a description of the cost. If the cost is 40, the cost is 'expensive'.*/

BOAT

PARTICIPANT

PASTRES

RESERVATION

SITE

TOUR

Columns Data Model Constraints Grants Statistics Triggers Flashback Dependencies Details Partitions Indexes SQL .1 Sort.. Filter BOAT IDBOAT NAMEBOAT TYPE 1 El Capitan Custom Modutech Dive Boat 2 Donni-Marie Coast Guard certified dive boat 3 El AstutoGulfcraft Coast Guard certified dive boat 4 La Rosa BOAT LENGTH 32 36 BOAT SPEED 10 20 BOAT CAPACITY BOAT YEAR 18 24 32 20 1995 2000 (null) 2004 Gulfcraft Coast Guard certified dive boat 40 12