Question

1. Write an Sql statement to display all the columns in the driver table Write an SQL statement to display the name, location, and certified for all drivers that have Certified equal to Y. Sort the results in descending order by driverid 3. Write an SQL statement to display the group the data by driverid so we can find the sum of hours and miles logged from timesheet 4. Write an update statement to set the certified to P for every row having a value of N 5. Using your student information, Write an SQL statement to insert the values 44, name, studentid, address, y, 1099 to the driver table 6. Write an SQL query to display the driverid and the sum of hours logged, sum of miles logged from timesheet group by driverid.

Answer 1

Part(A) : for displaying all columns present in driver table we use query as :

DESCRIBE [Table name] so here

DESCRIBE Driver

Part(B) :

Select name,location,certified where certified='Y'

ORDER BY driverId desc