Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM airports WHERE country = "Canada"
Feedback: Put routes instead of airports table , Departure country equals United States and Arriving country equals Canada .
Output (English): SELECT count(*) FROM routes WHERE dst_apid IN (SELECT apid FROM airports WHERE country  =  'Canada') AND src_apid IN (SELECT apid FROM airports WHERE country  =  'United States')