Which season had less than 25.4 viewers and had a viewer rank of #6?
CREATE TABLE table_name_43 (season INTEGER, households_viewers__in_millions_ VARCHAR, viewer_rank___number_ VARCHAR)
SELECT MIN(season) FROM table_name_43 WHERE households_viewers__in_millions_ < 25.4 AND viewer_rank___number_ = "#6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (season INTEGER, households_viewers__in_millions_ VARCHAR, viewer_rank___number_ VARCHAR) Question: Which season had less than 25.4 viewers and had a viewer rank of #6? [/INST] SELECT MIN(season) FROM table_name_43 WHERE households_viewers__in_millions_ < 25.4 AND viewer_rank___number_ = "#6" </s>