Which Total has a Hereditary peer of –, and a Lords spiritual of –, and a Life peers of 2, and an Affiliation of plaid cymru?
CREATE TABLE table_name_17 (total VARCHAR, affiliation VARCHAR, life_peers VARCHAR, hereditary_peers VARCHAR, lords_spiritual VARCHAR)
SELECT COUNT(total) FROM table_name_17 WHERE hereditary_peers = "–" AND lords_spiritual = "–" AND life_peers = "2" AND affiliation = "plaid cymru"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (total VARCHAR, affiliation VARCHAR, life_peers VARCHAR, hereditary_peers VARCHAR, lords_spiritual VARCHAR) Question: Which Total has a Hereditary peer of –, and a Lords spiritual of –, and a Life peers of 2, and an Affiliation of plaid cymru? [/INST] SELECT COUNT(total) FROM table_name_17 WHERE hereditary_peers = "–" AND lords_spiritual = "–" AND life_peers = "2" AND affiliation = "plaid cymru" </s>