user: ### NOW ANSWER:
Question: With a Primary military speciality of Astral assault tactics, what is the Secondary military speciality?
Columns: ['Code Name', 'Function (figure)', 'Real Name', 'Birthplace', 'Serial number', 'Primary military speciality', 'Secondary military speciality']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Sky Raider', 'Commander', "Charles 'Chuck' Connors", 'Cincinnati', 'AF 934101', 'Space battle tactics', 'Space command']
SQL:

assistant: SELECT "Secondary military speciality" FROM "Table" WHERE "Primary military speciality" = 'Astral assault tactics';