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

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'