-- 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 ] |
-- -- Among the flights operated by American Airlines Inc. on 2018/8/1, how many of them were cancelled?

SELECT SUM(CASE WHEN T2.CANCELLED = 1 THEN 1 ELSE 0 END) AS count FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.ORIGIN INNER JOIN `Air Carriers` AS T3 ON T2.OP_CARRIER_AIRLINE_ID = T3.Code WHERE T2.FL_DATE = '2018/8/1' AND T3.Description = 'American Airlines Inc.: AA';