Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE airport ( id number, city text, country text, iata text, icao text, name text )
TABLE: CREATE TABLE operate_company ( id number, name text, type text, principal_activities text, incorporated_in text, group_equity_shareholding number )
TABLE: CREATE TABLE flight ( id number, vehicle_flight_number text, date text, pilot text, velocity number, altitude number, airport_id number, company_id number )

### Question ###
List the vehicle flight number, date and pilot of all the flights, ordered by altitude.

### Accurate SQL ###

SELECT vehicle_flight_number, date, pilot FROM flight ORDER BY altitude