Table: csa_yearly_roles
Columns: year
human_resources_operations
local_affairs
academic_university_affairs
external_affairs

Question: Who was the Human Resources & Operations person between 2003-2004?
SQL: SELECT "human_resources_operations" FROM csa_yearly_roles WHERE "year" = '2003-2004'

Question: Who was in local affairs when the Human Resources & Operations was N. Charles Hamilton?
SQL: SELECT "local_affairs" FROM csa_yearly_roles WHERE "human_resources_operations" = 'n. charles hamilton'

Question: Who was in Human Resources & Operations when David Hornsby was in Academic & University Affairs?
SQL: SELECT "human_resources_operations" FROM csa_yearly_roles WHERE "academic_university_affairs" = 'david hornsby'

Question: Who was in external affairs when Jakki Doyle was in Human Resources & Operations?
SQL: SELECT "external_affairs" FROM csa_yearly_roles WHERE "human_resources_operations" = 'jakki doyle'

Question: Who was in local affairs in 2012-2013?
SQL: SELECT "local_affairs" FROM csa_yearly_roles WHERE "year" = '2012-2013'

Question: Who was in Academic & University Affairs when Andrew Langille  was in local affairs?
SQL: SELECT "academic_university_affairs" FROM csa_yearly_roles WHERE "local_affairs" = 'andrew langille'