Question

13. Write the SQL query commands based on the following table:
Table: SCHOOLBUS
Rtno Area Covered Capacity Noofstudents Distance
1 Vasant Kun) 100 120
10
2 Hauz Khas 80
80
10
3 Pitampura 60
55
30
4 Rohini
100 90
35
5 Yamuna Vihar 50
60
20
6 Krishna Nagar 70
80
30
7. Vasundhra 100 110
20
8 Paschim Vihar 40
40
20
9 Saket
120 120
10
10 Janak Puri 100 100
20
Transporter
Shivam Travels
Anand Travels
Anand Travels
Anand Travels
Bhalla Co.
Yadav Co.
Yadav Co.
Speed Travels
Speed Travels
Kisan Tours
Charges
100000
85000
60000
100000
55000
80000
100000
55000
100000
95000
(a) To show all information of students where capacity is more than the number of students in order a
rtno
(b) To show area covered for buses covering more than 20 km, but charge less than 80000.
(c) To show transporter-wise total no. of students travelling.
(d) To show rtno, area_covered and average cost per student for all routes where average cost pe
student is charges/no. of students.
(e) Add a new record with the following data:
(11, "Moti bagh",35,32,10, "kisan tours", 35000)​

Answer 1

Answer:

1 10000

2 3987

3 5573

4 6789

5 6543