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

Question: What is the real name of the person whose primary military specialty is shock paratrooper?
SQL: SELECT "real_name" FROM sas_recruits WHERE "primary_military_speciality" = 'shock paratrooper'

Question: What is the birthplace of Pete Sanderson?
SQL: SELECT "birthplace" FROM sas_recruits WHERE "real_name" = 'pete sanderson'

Question: What role did Jean-Luc Bouvier serve?
SQL: SELECT "function_figure" FROM sas_recruits WHERE "real_name" = 'jean-luc bouvier'

Question: What is the real name of the person who is a pilot of the silent attack kayak?
SQL: SELECT "real_name" FROM sas_recruits WHERE "function_figure" = 'pilot of the silent attack kayak'

Question: What is the code name of the person born in Liverpool?
SQL: SELECT "code_name" FROM sas_recruits WHERE "birthplace" = 'liverpool'