What rank does the person participating in American Civil war and indian wars?
CREATE TABLE table_name_65 (rank VARCHAR, active_service VARCHAR)
SELECT rank FROM table_name_65 WHERE active_service = "american civil war and indian wars"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (rank VARCHAR, active_service VARCHAR) Question: What rank does the person participating in American Civil war and indian wars? [/INST] SELECT rank FROM table_name_65 WHERE active_service = "american civil war and indian wars" </s>