SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline HAVING count(*)  <  200
Find all airlines that have fewer than 200 flights.
SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count ( * ) < 200
select t1 . airline from airlines as t1 join flights as t2 on t1 . uid = t2 . airline group by t1 . airline having count ( * ) < value
Find all airlines that have fewer than 200 flights .