Shard-Query demo queries

gistfile1.sql

select count(*)    
  from ontime_fact   
  join dim_date on ontime_fact.date_id = dim_date.date_id
 where `Year` between 1990 and 1994 and `Quarter` = 1;
 
 select FlightDate, count(*)    
  from ontime_fact   
  join dim_date on ontime_fact.date_id = dim_date.date_id
  join dim_flight on ontime_fact.flight_id = dim_flight.flight_id
 where `Year` = 1998 and `Quarter` = 1
   and Carrier = 'AA';