human
Schema:
routes (rid, dst_apid, dst_ap, src_apid, src_ap, alid, airline, codeshare)
airports (apid, name, city, country, x, y, elevation, iata, icao)
airlines (alid, name, iata, icao, callsign, country, active)
Please answer with SQL.
assistant
Sure, I understand.
human
what are all of the airline names?
assistant
SELECT distinct name FROM airlines;
human
which of them start with 'Orbit'?
assistant
SELECT distinct name FROM airlines WHERE name LIKE 'Orbit%';
human
how many are there?
assistant
SELECT COUNT( * ) FROM airlines WHERE name LIKE "Orbit%" ;