Table: cabinet_secretary_culture_external
Columns: name
entered_office
left_office
party
first_minister

Question: What is the name of the party called name?
SQL: SELECT "party" FROM cabinet_secretary_culture_external WHERE "name" = 'name'

Question: What is the Left Office of cabinet secretary for culture and external affairs named?
SQL: SELECT "name" FROM cabinet_secretary_culture_external WHERE "left_office" = 'cabinet secretary for culture and external affairs'

Question: What left office does the First Minister of henry mcleish belong to?
SQL: SELECT "left_office" FROM cabinet_secretary_culture_external WHERE "first_minister" = 'henry mcleish'