Find all airlines that have at least 10 flights.
create table flights (airline varchar, PRIMARY KEY (airline)); create table airlines (airline varchar, uid varchar, PRIMARY KEY (airline))
select t1.airline from airlines as t1 join flights as t2 on t1.uid = t2.airline group by t1.airline having count(*) > 10