Table: coleraine_council_members
Columns: year
name
political_affiliation
deputy
deputy_s_affiliation

Question: What Year was james mcclure Deputy, and the Name is robert mcphearson?
SQL: SELECT "year" FROM coleraine_council_members WHERE "deputy" = 'james mcclure' AND "name" = 'robert mcphearson'

Question: What is the name of the Deputy when the Name was elizabeth black?
SQL: SELECT "deputy" FROM coleraine_council_members WHERE "name" = 'elizabeth black'

Question: What is the Name for 1997–99?
SQL: SELECT "name" FROM coleraine_council_members WHERE "year" = '1997–99'

Question: What is the Political affiliation of deputy john dallat?
SQL: SELECT "political_affiliation" FROM coleraine_council_members WHERE "deputy" = 'john dallat'

Question: What is the name of the deputy in 1992–93?
SQL: SELECT "deputy" FROM coleraine_council_members WHERE "year" = '1992–93'

Question: What is the Deputy's affiliation in 1992–93?
SQL: SELECT "deputy_s_affiliation" FROM coleraine_council_members WHERE "year" = '1992–93'