SQL Query Commands

-- a. List all salespersons sorted by last name and within last name, first name.

-- b. List details (car cost & type) of the sales made by Robert King.

-- c. Report the number of cars sold of each type.

-- d. What is the average car cost of cars sold by Janet Lever ling?

-- e. Report details (salesperson, car cost and car type) of all sales where the car cost is less than the average.

-- f. What is the total car cost of all cars?

-- g. What is the total car cost of all cars that have sold?

-- h. List all salespersons with a number of the cars they've sold of each type

-- i. List car cost & type for all cars that have not sold --

j. List the number of cars of each type that have not sold

-- k. List salespersons who have not made a sale

-- l. List all salespersons and the total car cost of their sales; for salespersons without sales, a zero should be reported

-- m. This isn't a query; just type your response the SQL comments block below