SYS 2202 Lecture 9: 3.14-3.21_SELECT Statements

• School: University of Virginia
• Department: Systems & Information Engineering
• Course: SYS 2202
• Professor: Bass Ellen

Document Summary

Find the make, model, and year of all vehicles in the fleet made before 2007. Find the names of all employees with a last name beginning with the letter c. Where lastname >= c" and lastname < d"; Find all information on vehicles in the fleet, ordered from oldest to newest. Find all information on ford vehicles in the fleet, ordered from oldest to newest. Find all information on vehicles in the fleet, ordered from newest to oldest. Find all information about the oldest vehicle in the fleet. Find the total number of ford vehicles in the fleet. Find the total number of vehicles of each make in the fleet. Find information on the trips performed by each driver. Where drivers. id_number=trips. id_number: find information on the trips performed by joe smith : From drivers, trips: same as 10, using inner join. Where firstname="joe" and lastname = smith": find the make, model, and year of all vehicles driven by joe smith .