What is the lowest evening score of the contestant with an evening gown less than 8.938, from Texas, and with an average less than 8.846 has?
CREATE TABLE table_name_3 (interview INTEGER, average VARCHAR, evening_gown VARCHAR, state VARCHAR)
SELECT MIN(interview) FROM table_name_3 WHERE evening_gown < 8.938 AND state = "texas" AND average < 8.846
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (interview INTEGER, average VARCHAR, evening_gown VARCHAR, state VARCHAR) Question: What is the lowest evening score of the contestant with an evening gown less than 8.938, from Texas, and with an average less than 8.846 has? [/INST] SELECT MIN(interview) FROM table_name_3 WHERE evening_gown < 8.938 AND state = "texas" AND average < 8.846 </s>