Average RevPAR for InterContinental Hotel Group brands for Q1-Q3 2019 and Q1-Q3 2022. Original figures sourced from historical quarterly reports.

ihg

# Average RevPAR by brand (Q1 2019 to Q3 2019)

stocks_hotels=# select brand, avg(revpar) from ihg where year='2019' group by brand order by avg(revpar);
        brand        |         avg          
---------------------+----------------------
 Candlewood Suites   |  64.2366666666666667
 Holiday Inn         |  76.8833333333333333
 Holiday Inn Express |  80.9033333333333333
 Crowne Plaza        |  86.7833333333333333
 Staybridge Suites   |  93.4266666666666667
 Hotel Indigo        | 123.4366666666666667
 EVEN Hotels         | 139.3733333333333333
 InterContinental    | 153.3133333333333333
 Kimpton             | 195.9033333333333333
(9 rows)

# Average RevPAR by brand (Q1 2022 to Q3 2022)

stocks_hotels=# select brand, avg(revpar) from ihg where year='2022' group by brand order by avg(revpar);
        brand        |         avg          
---------------------+----------------------
 Crowne Plaza        |  72.3966666666666667
 Candlewood Suites   |  72.7566666666666667
 Holiday Inn         |  75.6000000000000000
 Holiday Inn Express |  85.6033333333333333
 Staybridge Suites   |  95.0433333333333333
 EVEN Hotels         | 106.6400000000000000
 Hotel Indigo        | 116.8600000000000000
 InterContinental    | 133.7000000000000000
 Kimpton             | 188.6800000000000000
(9 rows)

# Original Data

stocks_hotels=# select * from ihg;
        brand        | revpar |  adr   | year | quarter 
---------------------+--------+--------+------+---------
 InterContinental    | 150.84 | 226.12 | 2022 | Q3
 Kimpton             | 196.84 | 272.93 | 2022 | Q3
 Hotel Indigo        | 131.20 | 187.82 | 2022 | Q3
 Crowne Plaza        |  80.09 | 135.26 | 2022 | Q3
 EVEN Hotels         | 126.51 | 168.59 | 2022 | Q3
 Holiday Inn         |  87.08 | 132.27 | 2022 | Q3
 Holiday Inn Express |  96.03 | 132.69 | 2022 | Q3
 Staybridge Suites   | 102.81 | 128.49 | 2022 | Q3
 Candlewood Suites   |  77.28 |  99.01 | 2022 | Q3
 InterContinental    | 152.01 | 232.15 | 2022 | Q2
 Kimpton             | 213.63 | 296.95 | 2022 | Q2
 Hotel Indigo        | 131.38 | 185.30 | 2022 | Q2
 Crowne Plaza        |  78.32 | 134.62 | 2022 | Q2
 EVEN Hotels         | 121.17 | 163.17 | 2022 | Q2
 Holiday Inn         |  81.64 | 126.44 | 2022 | Q2
 Holiday Inn Express |  91.47 | 128.80 | 2022 | Q2
 Staybridge Suites   |  99.36 | 125.49 | 2022 | Q2
 Candlewood Suites   |  76.23 |  97.66 | 2022 | Q2
 InterContinental    |  98.25 | 198.21 | 2022 | Q1
 Kimpton             | 155.57 | 278.57 | 2022 | Q1
 Hotel Indigo        |  88.00 | 154.85 | 2022 | Q1
 Crowne Plaza        |  58.78 | 123.31 | 2022 | Q1
 EVEN Hotels         |  72.24 | 124.65 | 2022 | Q1
 Holiday Inn         |  58.08 | 111.67 | 2022 | Q1
 Holiday Inn Express |  69.31 | 114.74 | 2022 | Q1
 Staybridge Suites   |  82.96 | 116.27 | 2022 | Q1
 Candlewood Suites   |  64.76 |  90.37 | 2022 | Q1
 InterContinental    | 153.67 | 207.90 | 2019 | Q3
 Kimpton             | 196.31 | 235.73 | 2019 | Q3
 Hotel Indigo        | 127.42 | 167.22 | 2019 | Q3
 Crowne Plaza        |  89.00 | 128.23 | 2019 | Q3
 EVEN Hotels         | 148.74 | 174.72 | 2019 | Q3
 Holiday Inn         |  82.72 | 117.08 | 2019 | Q3
 Holiday Inn Express |  87.41 | 117.68 | 2019 | Q3
 Staybridge Suites   |  97.20 | 120.72 | 2019 | Q3
 Candlewood Suites   |  67.70 |  86.94 | 2019 | Q3
 InterContinental    | 163.10 | 218.34 | 2019 | Q2
 Kimpton             | 217.52 | 257.25 | 2019 | Q2
 Hotel Indigo        | 132.28 | 168.00 | 2019 | Q2
 Crowne Plaza        |  92.52 | 130.81 | 2019 | Q2
 EVEN Hotels         | 162.98 | 189.63 | 2019 | Q2
 Holiday Inn         |  81.34 | 116.62 | 2019 | Q2
 Holiday Inn Express |  84.95 | 116.79 | 2019 | Q2
 Staybridge Suites   |  96.94 | 121.39 | 2019 | Q2
 Candlewood Suites   |  67.38 |  87.11 | 2019 | Q2
 InterContinental    | 143.17 | 207.44 | 2019 | Q1
 Kimpton             | 173.88 | 236.78 | 2019 | Q1
 Hotel Indigo        | 110.61 | 156.91 | 2019 | Q1
 Crowne Plaza        |  78.83 | 125.55 | 2019 | Q1
 EVEN Hotels         | 106.40 | 142.55 | 2019 | Q1
 Holiday Inn         |  66.59 | 109.54 | 2019 | Q1
 Holiday Inn Express |  70.35 | 110.58 | 2019 | Q1
 Staybridge Suites   |  86.14 | 118.18 | 2019 | Q1
 Candlewood Suites   |  57.63 |  84.17 | 2019 | Q1