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: Nomeie o cônjuge de Louise de Hesse-Kassel.
 ###Tabelas: CREATE TABLE season_6_2009–11 (season_6_2009–11_id AUTO_INCREMENT PRIMARY KEY, Series # INT, Season # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production code INT) CREATE TABLE zakopane (zakopane_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Nationality VARCHAR, 1st (m) INT, Points INT, Overall WC points (Rank) VARCHAR) CREATE TABLE riff_awards (riff_awards_id AUTO_INCREMENT PRIMARY KEY, Year INT, Dates VARCHAR, Discovery of the Year (Golden Puffin) VARCHAR, Lifetime Achievement VARCHAR, Creative Excellency VARCHAR, Audience Award VARCHAR, FIPRESCI Award VARCHAR, Church of Iceland Award VARCHAR) CREATE TABLE pool_h (pool_h_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Time VARCHAR, Score VARCHAR, Set 1 VARCHAR, Set 2 VARCHAR, Set 3 VARCHAR, Total VARCHAR) CREATE TABLE house_of_schleswig-holstein-sonderburg-glücksburg (house_of_schleswig-holstein-sonderburg-glücksburg_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Birth VARCHAR, Marriage VARCHAR, Became Consort VARCHAR, Ceased to be Consort VARCHAR, Spouse VARCHAR)  
SELECT Spouse FROM house_of_schleswig-holstein-sonderburg-glücksburg WHERE Name = louise of hesse-kassel