CREATE TABLE Flight (flno VARCHAR2, distance VARCHAR2)

Show the flight number of flights with three lowest distances.
SELECT flno FROM Flight ORDER BY distance LIMIT 3
SELECT "flno" FROM "Flight" ORDER BY "distance" FETCH FIRST 3 ROWS ONLY