Exploring the databases and airline tables

Use Hue to look up existing databases, tables, and data that is available in your data warehouse.

Log in to Hue with your credentials.
Explore the databases and airline tables from the left-assist panel.

Run the following query to get a list of international flights:

-- Query to find all international flights: flights where destination airport country is not the same as origin airport country
SELECT DISTINCT 
   flightnum, 
   uniquecarrier, 
   origin, 
   dest, 
   month, 
   dayofmonth, 
   `dayofweek`
FROM 
   `airline_ontime_orc`.flights f, 
   `airline_ontime_orc`.airports oa, 
   `airline_ontime_orc`.airports da  
WHERE 
   f.origin = oa.iata 
   and f.dest = da.iata 
   And oa.country <> da.country 
ORDER BY
   month ASC, 
   dayofmonth ASC  
;