Table: csa_yearly_report
Columns: year
communications_and_corporate_affairs
human_resources_operations
local_affairs
academic_university_affairs
external_affairs

Question: Who is the academic & University affairs when the Human resources & operations is N. Charles Hamilton?
SQL: SELECT "academic_university_affairs" FROM csa_yearly_report WHERE "human_resources_operations" = 'N. Charles Hamilton'

Question: What year was communications and corporate affairs held by Jeff Rotman?
SQL: SELECT "year" FROM csa_yearly_report WHERE "communications_and_corporate_affairs" = 'Jeff Rotman'