Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quem era o comentarista de cor quando o locutor de jogada a jogada era Bob Cole?
 ###Tabelas: CREATE TABLE calculations (calculations_id AUTO_INCREMENT PRIMARY KEY, Level INT, Shuttles INT, Cumulative Shuttles INT, Speed (km/h) VARCHAR, Shuttle Time (seconds) VARCHAR, Total level time (s) VARCHAR, Distance (m) INT, Cumulative Distance (m) INT, Cumulative Time (min and seconds) VARCHAR) CREATE TABLE 1980s (1980s_id AUTO_INCREMENT PRIMARY KEY, Year INT, Network VARCHAR, Play-by-play VARCHAR, Colour commentator(s) VARCHAR, Studio host VARCHAR) CREATE TABLE winners_by_country (winners_by_country_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Total INT, Marathon (mens) INT, Marathon (womens) INT, Half Marathon (mens) INT, Half Marathon (womens) INT) CREATE TABLE challenger_and_futures_runner-up_5 (challenger_and_futures_runner-up_5_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Opponent VARCHAR, Score VARCHAR) CREATE TABLE singles_15 (singles_15_id AUTO_INCREMENT PRIMARY KEY, Edition VARCHAR, Round VARCHAR, Date VARCHAR, Against VARCHAR, Surface VARCHAR, Opponent VARCHAR, Result VARCHAR)  
SELECT Colour commentator(s) FROM 1980s WHERE Play-by-play = bob cole