What is the smallest Weight, when Spike is less than 330, when Block is 315, and when Height is greater than 187?
CREATE TABLE table_name_78 (weight INTEGER, height VARCHAR, spike VARCHAR, block VARCHAR)
SELECT MIN(weight) FROM table_name_78 WHERE spike < 330 AND block = 315 AND height > 187
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (weight INTEGER, height VARCHAR, spike VARCHAR, block VARCHAR) Question: What is the smallest Weight, when Spike is less than 330, when Block is 315, and when Height is greater than 187? [/INST] SELECT MIN(weight) FROM table_name_78 WHERE spike < 330 AND block = 315 AND height > 187 </s>