Table: minister_info
Columns: name
entered_office
left_office
party
first_minister

Question: When did first minister Henry Mcleish enter office?
SQL: SELECT "entered_office" FROM minister_info WHERE "first_minister" = 'henry mcleish'

Question: What is the name of the minister that left office on 14 November 2006?
SQL: SELECT "name" FROM minister_info WHERE "left_office" = '14 november 2006'

Question: What is the name of the minister from the party of minister for community safety and legal affairs?
SQL: SELECT "name" FROM minister_info WHERE "party" = 'minister for community safety and legal affairs'

Question: What is the name of the minister who has an entered office of entered office?
SQL: SELECT "name" FROM minister_info WHERE "entered_office" = 'entered office'

Question: What is the party of the minister who left office on 26 November 2002?
SQL: SELECT "party" FROM minister_info WHERE "left_office" = '26 november 2002'

Question: What is the party of Richard Simpson?
SQL: SELECT "party" FROM minister_info WHERE "name" = 'richard simpson'