Question

A relation Vehicles is given below :

V_no	Type	Company	Price	Qty
AW125	Wagon	Maruti	250000	25
J0083	Jeep	Mahindra	4000000	15
S9090	SUV	Mitsubishi	2500000	18
M0892	Mini van	Datsun	1500000	26
W9760	SUV	Maruti	2500000	18
R2409	Mini van	Mahindra	350000	15

Write SQLcommands to:

a. Display the average price of each type of vehicle having quantity more than 20.

b. Count the type of vehicles manufactured by each company.

c. Display the total price of all the types of vehicles.

Answer 1

a. select Type, avg(Price) from Vehicle group by Type having Qty>20;

b. select Company, count(distinct Type) from Vehicle group by Company;

c. Select Type, sum(Price* Qty) from Vehicle group by Type;