What are the speeds of the longest roller coaster?
CREATE TABLE country (
    country_id number,
    name text,
    population number,
    area number,
    languages text
)

CREATE TABLE roller_coaster (
    roller_coaster_id number,
    name text,
    park text,
    country_id number,
    length number,
    height number,
    speed text,
    opened text,
    status text
)
SELECT speed FROM roller_coaster ORDER BY length DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the speeds of the longest roller coaster? ### Input: CREATE TABLE country (
    country_id number,
    name text,
    population number,
    area number,
    languages text
)

CREATE TABLE roller_coaster (
    roller_coaster_id number,
    name text,
    park text,
    country_id number,
    length number,
    height number,
    speed text,
    opened text,
    status text
) ### Response: SELECT speed FROM roller_coaster ORDER BY length DESC LIMIT 1