Using the vehicle database in Appendix A (provided below) , answer in SQL statements for each of
Question:
Using the vehicle database in Appendix A (provided below), answer in SQL statements for each of the following queries.
a) Using SQL statement, show the name of employees who are in business or administration.
b) Find the ergo numbers of cars that were taken by employee number 118.
c) Find the cars that were used by Employees in the Information Tech Department.
d) Find the number of cars used by employees whose number is above 120, excluding those employees who are part of the Information tech department.
e) Find the name and department of the employees, who have taken a Mazda and Ford car between 11/08/2011 and 11/09/2011.
f) Find the employee names who used the most cars.
g) Find the employee/s who returned a vehicle on 15/11/2011.
h) Find the employee/s who taken a vehicle on 02/09/2011 and 12/09/2011.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill