SQL 1) List slTrip. TripID, slTrip. TripStart, slTrip. WaterTemp, and slLaunch. Launch for all trips.
Order the list by sltrip. TripID in ascending order.
2) List slGearPurchase. GearPurchaseID, slGearPurchase. PurchaseAmount, and slSupplier. SupplierName for gear purchases for the year 2010 and for purchase amounts greater than 20.
Order the list by slGearPurchase. PurchaseDate in ascending order.
3) List slPax. PaxID, slPax. PaxFirstName, slPax. PaxLastName, and slCensus. PaxOrder for passengers with the lastname 'lozano'.
Order the list by slCensus. PaxOrder in ascending order.
4) List slShip. Make, slMaintenance. MaintenanceDate, and slSupplier. SupplierName for maintenance items with cost between 50 and 75.
Order the list by slMaintenance. MaintenanceDate in ascending order.
5) List slTrip. TripID, slTrip. TripStart, slLaunch. Launch, Passenger, and slShip. Make for TripID 100. This query provides the list of passengers and the launch for a given trip.
Passenger is the concatenation of first and last name with a blank in between.
Order the list by slCensus. PaxOrder in ascending order.
6) List slTrip. TripID, slTrip. TripEnd, slTrip. WaterTemp, slLaunch. Launch, slShip. Make, and CaptainName for trips with a water temperature greater than 88 and for which the trip ended in the afternoon.
CaptainName is the concatenation of first and last name with a blank in between.
Derive the hour from slTrip. TripEnd using DATEPART() and the HOUR interval. A trip that ends in the afternoon will have a DATEPART() value greater than or equal to 12.
Order the list by slTrip. TripID in ascending order.