With a Primary military speciality of astral assault tactics, what is the Secondary military speciality?
CREATE TABLE table_name_58 (secondary_military_speciality VARCHAR, primary_military_speciality VARCHAR)
SELECT secondary_military_speciality FROM table_name_58 WHERE primary_military_speciality = "astral assault tactics"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_58 (secondary_military_speciality VARCHAR, primary_military_speciality VARCHAR) Question: With a Primary military speciality of astral assault tactics, what is the Secondary military speciality? [/INST] SELECT secondary_military_speciality FROM table_name_58 WHERE primary_military_speciality = "astral assault tactics" </s>