Adjust this query to include the Geo_Regions select count(*) as count_flights ,sum(passenger) AS sum_passenger ,substr(activity_period, 1, 4)
Fantastic news! We've Found the answer you've been seeking!
Question:
Adjust this query to include the Geo_Regions
select count(*) as count_flights ,sum(passenger) AS sum_passenger ,substr(activity_period, 1, 4) as txn_year from default.sfo_monthly_air_traffic_passengers_datagroup by substr(activity_period, 1, 4)
Expert Answer:
Related Book For 
Accounting Information Systems
ISBN: 978-1133935940
10th edition
Authors: Ulric J. Gelinas, Richard B. Dull
Posted Date:
