Page 98 - IPP-12-2024

iv) To show rtno, area_covered and average cost per student for all routes where average cost per
student is - charges/noofstudents.

v) Add a new record with following data:

(11, “ Moti bagh”,35,32,10,” kisan tours “, 35000)

II. Give the output of the following query:
(i) select sum(distance) from schoolbus where transporter= "Yadav
travels";

sum(distance)

1

0

(ii) select min(noofstudents) from schoolbus;
min(noofstudents)

4

0