I want the constituency which has a swing to gain less than 6.05 and a rank of 2
CREATE TABLE table_name_4 (constituency VARCHAR, swing_to_gain VARCHAR, rank VARCHAR)
SELECT constituency FROM table_name_4 WHERE swing_to_gain < 6.05 AND rank = 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (constituency VARCHAR, swing_to_gain VARCHAR, rank VARCHAR) Question: I want the constituency which has a swing to gain less than 6.05 and a rank of 2 [/INST] SELECT constituency FROM table_name_4 WHERE swing_to_gain < 6.05 AND rank = 2 </s>