CREATE TABLE country (country_id NUMBER, name CLOB, population NUMBER, area NUMBER, languages CLOB)
CREATE TABLE roller_coaster (roller_coaster_id NUMBER, name CLOB, park CLOB, country_id NUMBER, length NUMBER, height NUMBER, speed CLOB, opened CLOB, status CLOB)

What are the speeds of the longest roller coaster?
SELECT speed FROM roller_coaster ORDER BY length DESC LIMIT 1
SELECT "speed" FROM "roller_coaster" ORDER BY "length" DESC FETCH FIRST 1 ROWS ONLY