SELECT T1.name ,  T1.type FROM operate_company AS T1 JOIN flight AS t2 ON T1.id  =  T2.company_id
What are the names and types of the companies that have ever operated a flight?
SELECT T1.name , T1.type FROM operate_company AS T1 JOIN flight AS t2 ON T1.id = T2.company_id
select t1 . name , t1 . type from operate_company as t1 join flight as t2 on t1 . id = t2 . company_id
What are the names and types of the companies that have ever operated a flight ?