Average passenger revenue by region for Air Canada (Q1 to Q3 2019 and Q1 to Q3 2022). Original figures sourced from historical quarterly reports by Air Canada.

air_canada

# Average revenue by region from Q1 to Q3 2022

stocks_airlines=# select region, avg(passenger_revenues) from aircanada where year='2022' group by region order by avg(passenger_revenues);
      region      |          avg          
------------------+-----------------------
 Pacific          |  235.3333333333333333
 Other            |  285.0000000000000000
 U.S. Transborder |  700.3333333333333333
 Canada           | 1076.3333333333333333
 Atlantic         | 1095.0000000000000000
(5 rows)

# Average revenue by region from Q1 to Q3 2019

stocks_airlines=# select region, avg(passenger_revenues) from aircanada where year='2019' group by region order by avg(passenger_revenues);
      region      |          avg          
------------------+-----------------------
 Other            |  324.3333333333333333
 Pacific          |  632.3333333333333333
 U.S. Transborder |  968.6666666666666667
 Atlantic         | 1183.3333333333333333
 Canada           | 1330.6666666666666667
(5 rows)

# Full Data

stocks_airlines=# select * from aircanada;
      region      | passenger_revenues | year | quarter 
------------------+--------------------+------+---------
 Atlantic         |               1770 | 2022 | Q3
 Atlantic         |               1051 | 2022 | Q2
 Atlantic         |                464 | 2022 | Q1
 Atlantic         |               1624 | 2019 | Q3
 Atlantic         |               1159 | 2019 | Q2
 Atlantic         |                767 | 2019 | Q1
 Canada           |               1466 | 2022 | Q3
 Canada           |               1115 | 2022 | Q2
 Canada           |                648 | 2022 | Q1
 Canada           |               1550 | 2019 | Q3
 Canada           |               1338 | 2019 | Q2
 Canada           |               1104 | 2019 | Q1
 Other            |                285 | 2022 | Q3
 Other            |                288 | 2022 | Q2
 Other            |                282 | 2022 | Q1
 Other            |                249 | 2019 | Q3
 Other            |                261 | 2019 | Q2
 Other            |                463 | 2019 | Q1
 Pacific          |                382 | 2022 | Q3
 Pacific          |                226 | 2022 | Q2
 Pacific          |                 98 | 2022 | Q1
 Pacific          |                741 | 2019 | Q3
 Pacific          |                621 | 2019 | Q2
 Pacific          |                535 | 2019 | Q1
 U.S. Transborder |                915 | 2022 | Q3
 U.S. Transborder |                761 | 2022 | Q2
 U.S. Transborder |                425 | 2022 | Q1
 U.S. Transborder |               1000 | 2019 | Q3
 U.S. Transborder |                959 | 2019 | Q2
 U.S. Transborder |                947 | 2019 | Q1
(30 rows)