Table: space_force_members
Columns: code_name
function_figure
real_name
birthplace
serial_number
primary_military_speciality
secondary_military_speciality

Question: What Function (figure) has Serial number AF 934103?
SQL: SELECT "function_figure" FROM space_force_members WHERE "serial_number" = 'af 934103'

Question: What is Moondancer's Primary Military Speciality?
SQL: SELECT "primary_military_speciality" FROM space_force_members WHERE "code_name" = 'moondancer'

Question: With a Primary military speciality of astral assault tactics, what is the Secondary military speciality?
SQL: SELECT "secondary_military_speciality" FROM space_force_members WHERE "primary_military_speciality" = 'astral assault tactics'

Question: What is the Serial number for the Space Security Trooper Function (figure)?
SQL: SELECT "serial_number" FROM space_force_members WHERE "function_figure" = 'space security trooper'

Question: What is the Code Name for the Space Pilot Function (figure)?
SQL: SELECT "code_name" FROM space_force_members WHERE "function_figure" = 'space pilot'

Question: What Birthplace's Real Name is Charles 'Chuck' Connors?
SQL: SELECT "birthplace" FROM space_force_members WHERE "real_name" = 'charles ''chuck'' connors'