CREATE TABLE table_14946 ("Code Name" TEXT, "Function  ( figure ) " TEXT, "Real Name" TEXT, "Birthplace" TEXT, "Serial number" TEXT, "Primary military speciality" TEXT, "Secondary military speciality" TEXT)

What is Moondancer's Primary Military Speciality?
SELECT "Primary military speciality" FROM table_14946 WHERE "Code Name" = 'moondancer'
SELECT "Primary military speciality" FROM "table_14946" WHERE "Code Name" = 'moondancer'