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 treinador adversário com o resultado L, 56-6?
 ###Tabelas: CREATE TABLE table_of_nominations (table_of_nominations_id AUTO_INCREMENT PRIMARY KEY, Week 1 VARCHAR, Week 2 VARCHAR, Week 6 VARCHAR, Week 9 VARCHAR, Week 12 VARCHAR) CREATE TABLE season_1_2007 (season_1_2007_id AUTO_INCREMENT PRIMARY KEY, Series no. INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production Code INT) CREATE TABLE meistriliiga_clubs_2013 (meistriliiga_clubs_2013_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Position in 2012 VARCHAR, First season in top division INT, Number of seasons in Meistriliiga INT, First season of current spell in top division INT, Top division titles INT) CREATE TABLE the_final (the_final_id AUTO_INCREMENT PRIMARY KEY, Position INT, Artist VARCHAR, Song VARCHAR, Lyrics (l) / Music (m) VARCHAR, Place VARCHAR) CREATE TABLE charleston_southern_vs_fbs_schools (charleston_southern_vs_fbs_schools_id AUTO_INCREMENT PRIMARY KEY, Year INT, FBS Opponent VARCHAR, Result VARCHAR, Opponents Conference VARCHAR, Opponents Head Coach VARCHAR, Charleston Southerns Head Coach VARCHAR)  
SELECT Opponents Head Coach FROM charleston_southern_vs_fbs_schools WHERE Result = L, 56-6