SQL Queries: Flights database

$1.)$ Using the flights.m$\_$ticket$\_$prices and the m$\_$airports table, find the distinct routes $($route is a distinct origin$-$destination pair$)$ where the origin and the destination are part of the same state; in the output show the origin, dest, and the state of the airports.

$2.)$ Use the table flights.m$\_$ticket$\_$prices. For each route $($origin$-$destination pair$),$ list the following statistics:

cheapest fare

most expensive fare

the average fare

number of carriers serving the route

total number of passengers for the route

Report results only for routes with at least $3$ carriers an