Find the day in which the difference between the max temperature and min temperature was the smallest. Also report the difference.
CREATE TABLE weather (date VARCHAR, max_temperature_f VARCHAR, min_temperature_f VARCHAR)
SELECT TOP 1 date, max_temperature_f - min_temperature_f FROM weather ORDER BY max_temperature_f - min_temperature_f
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE weather (date VARCHAR, max_temperature_f VARCHAR, min_temperature_f VARCHAR) Question: Find the day in which the difference between the max temperature and min temperature was the smallest. Also report the difference. [/INST] SELECT TOP 1 date, max_temperature_f - min_temperature_f FROM weather ORDER BY max_temperature_f - min_temperature_f </s>