a) To show all information of students where capacity is more than the number of students in order of Rt no.

b) To show Area_Covered for busses covering more than 20 km, but charge less than 80000.

c) To show transporter-wise total no of students travelling.

d) To show Rt no, Area_covered and average cost per student for all routes where average cost per student is – charges/no of students.

e) Add a new record with the following data: (11, ‘Moti Bagh’, 35, 32, 10, “Kisan Tours”, 35000)

f) Give the output considering the original relation as given :

(i) Select sum(distance) from school where transporter= “Yadav Co.”;

(ii) Select min(no of students) from school bus;

(iii) Select avg (charges) from school bus where transporter = “Anand Travels”;