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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE building (name VARCHAR, street_address VARCHAR, floors VARCHAR) Question: Show the name, street address, and number of floors for all buildings ordered by the number of floors. [/INST] SELECT name, street_address, floors FROM building ORDER BY floors </s>