SQL HOMEWORK

Homework #6 Subqueries

Complete the following queries.

a) Use subqueries to answer the following questions

Which drivers begin trips at Olympia with an Effective Date in January 2005?

Do any drivers use more than one bus on their run where the Bid Date is in September 2004?

Which drivers make trips that last longer than 45 minutes?

Which trips are operated by Phantoms and have an Effective Date in 2005?

b) Answer the same questions using inner- or natural joins (where clause is used for the join).

c) Display trips with an Effective Date in 2005 made by Operators with less than three years on the job.

Reference

Operators Runs Vehicles PK OperatorlD PK RunID PK VehiclelD SeniorityNumber FirstName LastName Manufacturer Model Year PurchaseDate FK1 OperatorlD BidDate Schedule PK SchedulelD FK1 RunlD FK2 VehiclelD Trips PK TriplD FK1 SchedulelD StartLocation StartTime EndLocation EndTime EffectiveDate