If you can do it, I will send the Excel sheet.
Queries to Extract Data from drivers and timesheet
Each below SQL statement has a value of 10 points.
Import the driver and timesheet spreadsheet data into a database
Write an SQL statement to retrieve all the columns, all rows in the driver table
Write an SQL statement to display a list of all drivers, showing only driverid, name and the wage plan details
Write an SQL statement to display the name, location, and certified for all drivers that have Certified equal to N.
Write an SQL statement to produce a list of drivers that have Certified equal to Y, arranged in descending order by driverid
Write an SQL statement to find the sum, minimum, maximum, and averagemiles logged from timesheet group by driverid.
Write an update statement to set the Certified field to T for every row having a value of N
How many drivers are in the drivers table? Note use Count and Alias to give the column a temporary name
Using your student information,
Promote all drivers (certified = ‘Y’) to certified = ‘P’
Sample Solution