CREATE TABLE airport (id DECIMAL, city TEXT, country TEXT, iata TEXT, icao TEXT, name TEXT)
CREATE TABLE flight (id DECIMAL, vehicle_flight_number TEXT, date TEXT, pilot TEXT, velocity DECIMAL, altitude DECIMAL, airport_id DECIMAL, company_id DECIMAL)
CREATE TABLE operate_company (id DECIMAL, name TEXT, type TEXT, principal_activities TEXT, incorporated_in TEXT, group_equity_shareholding DECIMAL)

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"