Which District has a Party of republican and a Result of lost re-election democratic gain?
CREATE TABLE table_name_82 (district VARCHAR, party VARCHAR, result VARCHAR)
SELECT district FROM table_name_82 WHERE party = "republican" AND result = "lost re-election democratic gain"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_82 (district VARCHAR, party VARCHAR, result VARCHAR) Question: Which District has a Party of republican and a Result of lost re-election democratic gain? [/INST] SELECT district FROM table_name_82 WHERE party = "republican" AND result = "lost re-election democratic gain" </s>