create view average_ride_distance_for_each_vehicle as select Vehicle_Type,AVG (Ride_Distance) as booking from bookings group by Vehicle_Type; ...