-- Database schema
| Air Carriers : Code [ INTEGER ] primary_key , Description [ TEXT ] | Airports : Code [ TEXT ] primary_key , Description [ TEXT ] | Airlines : FL_DATE [ TEXT ] , OP_CARRIER_AIRLINE_ID [ INTEGER ] Airlines.OP_CARRIER_AIRLINE_ID = Air Carriers.Code , TAIL_NUM [ TEXT ] , OP_CARRIER_FL_NUM [ INTEGER ] , ORIGIN_AIRPORT_ID [ INTEGER ] , ORIGIN_AIRPORT_SEQ_ID [ INTEGER ] , ORIGIN_CITY_MARKET_ID [ INTEGER ] , ORIGIN [ TEXT ] Airlines.ORIGIN = Airports.Code , DEST_AIRPORT_ID [ INTEGER ] , DEST_AIRPORT_SEQ_ID [ INTEGER ] , DEST_CITY_MARKET_ID [ INTEGER ] , DEST [ TEXT ] Airlines.DEST = Airports.Code , CRS_DEP_TIME [ INTEGER ] , DEP_TIME [ INTEGER ] , DEP_DELAY [ INTEGER ] , DEP_DELAY_NEW [ INTEGER ] , ARR_TIME [ INTEGER ] , ARR_DELAY [ INTEGER ] , ARR_DELAY_NEW [ INTEGER ] , CANCELLED [ INTEGER ] , CANCELLATION_CODE [ TEXT ] , CRS_ELAPSED_TIME [ INTEGER ] , ACTUAL_ELAPSED_TIME [ INTEGER ] , CARRIER_DELAY [ INTEGER ] , WEATHER_DELAY [ INTEGER ] , NAS_DELAY [ INTEGER ] , SECURITY_DELAY [ INTEGER ] , LATE_AIRCRAFT_DELAY [ INTEGER ] |
-- -- What is the total number of flights that flew on August 2, 2018 with air carrier described as Horizon Air?

SELECT COUNT(*) FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description LIKE '%Horizon Air%' AND T2.FL_DATE = '2018/8/2';