Page 2 - Home Assignment-Grouping Records and Joins in SQL

Note: PERKM is Freight Charges per Kilometer

Note: KM is Kilometers travelled

NOP is the number of passengers travelled in vehicle

i) To display Customer name, travel date, vehicle type along with trip charges from
the tables above in ascending order of travel date.
ii) Display all travelling details for the persons availed bus services.
iii) Display number of persons travelled for each vehicle type.
iv) To display maximum distance covered by each vehicle from the table Vehicle.
v) To display number of trips and total passenger from the table Travel for each
vehicle, sort the data in ascending order of vehicle type.