How many company commanders were commissioned or elected on November 12, 1861?
CREATE TABLE table_29023680_2 (company VARCHAR, date_of_election_commission VARCHAR)
SELECT COUNT(company) AS Commander FROM table_29023680_2 WHERE date_of_election_commission = "November 12, 1861"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_29023680_2 (company VARCHAR, date_of_election_commission VARCHAR) Question: How many company commanders were commissioned or elected on November 12, 1861? [/INST] SELECT COUNT(company) AS Commander FROM table_29023680_2 WHERE date_of_election_commission = "November 12, 1861" </s>