user: ### NOW ANSWER:
Question: What is Moondancer's Primary 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 "Primary military speciality" FROM "Table" WHERE "Code Name" = 'Moondancer';