CREATE TABLE routes (alid VARCHAR(255)); CREATE TABLE airlines (alid VARCHAR(255), name VARCHAR(255))
Find the number of routes operated by American Airlines.
    
SQL: SELECT COUNT(*) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid = T2.alid WHERE T1.name = 'American Airlines'