Table: us_military_leaders
Columns: rank_order
rank
name
date
active_service

Question: What rank does the person participating in American Civil war and indian wars?
SQL: SELECT "rank" FROM us_military_leaders WHERE "active_service" = 'american civil war and indian wars'