user: ### NOW ANSWER:
Question: What rank does the person participating in American Civil War and Indian Wars?
Columns: ['Rank order', 'Rank', 'Name', 'Date', 'Active service']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [13.0, 'Admiral', 'David G. Farragut', '25 July 1866', 'War of 1812 , Mexican War , and American Civil War']
SQL:

assistant: SELECT "Rank" FROM "Table" WHERE "Active service" = 'American Civil War and Indian Wars';