Write sql commands to the following:- 1. display the average price of each type of vehicle having quantity more that 20.
2. count the type of vehicle manufactured by each company
3. display the total price of all the types of vehicles

pls answerrr...

I can't seem to add SQL to the answer, so let's try this:

For the first one, you need to build a select that uses the avg function on the price column.

For the second one, you need to use the count function.  Select that and the company, and group by company.

For the third, it's slightly unclear.  Do they mean to mean to display the total price of all vehicles or the total price of each type of vehicle.  The former would just be done by selecting a sum of the price.  The latter by selecting that and the type column, grouping by type.  I'm not sure if type is a keyword, so you might need backtick quotes wrapped around it.