SQL EXERCISE

Each query in this exercise relies on a single table, but may require returning specific rows (the WHERE clause); specific groups (GROUP BY, HAVING); using specific order (ORDER BY); with calculations (SELECT, WHERE)

Using Select

Complete the following queries.

1) Display the elapsed trip time for all trips.

2) Display route number, start location end location (one field), and start time for trips departing between 8:00am and 4:00pm in January 2005.

3) Calculate the length of service in years for all operators (difference between hire date and the current date).

4) How many 2005 trips start or end in Yelm?

5) Display the total number of operators hired each year.

6) Display the number of operators hired in each year where more than one operator was hired.

7) How many operators have worked for more than three years?

8) What is the total elapsed time for all September 2004 trips serving Westfield Shopping Mall?