Which of these is operated by American Airlines?
SELECT * FROM airlines AS T1 JOIN routes AS T2 ON T1.alid   =   T2.alid WHERE T1.name   =   'American Airlines'
operated by American Airlines refers to filtering records by airline name equal to 'American Airlines'; JOIN operation is used to combine records from two tables based on a related column between them, here it is alid.