Return the name and id of the furniture with the highest market rate.
CREATE TABLE furniture (name VARCHAR, furniture_id VARCHAR, market_rate VARCHAR)
SELECT TOP 1 name, furniture_id FROM furniture ORDER BY market_rate DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE furniture (name VARCHAR, furniture_id VARCHAR, market_rate VARCHAR) Question: Return the name and id of the furniture with the highest market rate. [/INST] SELECT TOP 1 name, furniture_id FROM furniture ORDER BY market_rate DESC </s>