Show the name, street address, and number of floors for all buildings ordered by the number of floors.
CREATE TABLE building (
    name VARCHAR,
    street_address VARCHAR,
    floors VARCHAR
)
SELECT name, street_address, floors FROM building ORDER BY floors
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: Show the name, street address, and number of floors for all buildings ordered by the number of floors. ### Input: CREATE TABLE building (
    name VARCHAR,
    street_address VARCHAR,
    floors VARCHAR
) ### Response: SELECT name, street_address, floors FROM building ORDER BY floors