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