SQL 1. List slCensus. TripID and PaxCnt for trips in the year 2010 for which the captain took the ship out alone (solo). PaxCnt is the count of the number of passengers (PaxID) in 2010 where the count is equal to 1. Order the list by slCensus. TripID in ascending order.
2. List TripDuration and AVGwaterTemp for trips taken by passenger with slCensus. PaxID = 173 for trips where the duration of the trip was greater than 1 hour. TripDuration is the difference between slTrip. TripStart and slTrip. TripEnd in hours. Produce the values for and group by TripDuration using DATEDIFF and the HOUR interval. Order the list by TripDuration in ascending order.
3. List DISTINCT slWayPoint. WayPoint for passenger with slCensus. PaxID 108 for trips in the year 2010. Order the list by slWayPoint. WayPoint in ascending order.
4. List the Last time the ship was launched from the Causeway where waypoint Pinto Island was on the float plan. LastTrip is the maximum value of slTrip. TripStart where the launchID is 2 and waypointID is 932