Question

Consider the following table:
SchoolBus
Runo Area_Covered Capacity Noofstud
Distance
Transport Charges
er
60
4
Vasant_kunj
100
120
10
Shivam 100000
Travels
2
Hauz Khas
80
80
10
Anand 95000
Travels
3
Pitampura
55
30
Anand 60000
Travels
Rohini
100
90
35
Shivam, 75000
Travels
5 Yamuna Vihar 50
60
30
Anand 55000
Travels
Write the SQL commands for the following:
i) To count number of schoolbus transporter wise.
ii) To show transporter wise average charges for all routes having charges more
than 60000.
iii) To show transporter wise total number of students travelling.​

Answer 1

Answer:

2. Match the following:

Column I

Column II

a.

Lines tool

b. Text tool

i.

Drawing Canvas in Tux Paint

ii. Repeats the drawing action

iïi. Straight Lines

iv. Insert text and Numbers

C. Magic Tool

d.

Redo option

e.

Canvas

V. Magical Effects