Average price

Problem Statement

You are given two tables: routes and tickets representing a travel agency's route and ticket details. Task Write a query to find the average price of tickets for each route. Arrange the output in the increasing order of route_id . The average price calculated should be rounded up to two decimal places. Table description Input format Table: routes Name Type Description route_id Integer Represents the unique ID of the route origin_city Varchar Represents the name of the origin city destination_city Varchar Represents the name of the destination city distance Decimal Represents the distance between the origin city and the destination city Table: tickets [unclear]