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: Quando o Premier Sir Charles Cowper (1807-1875) KCMG assumiu o cargo?
 ###Tabelas: CREATE TABLE step_races (step_races_id AUTO_INCREMENT PRIMARY KEY, !Race name INT, Grade VARCHAR, Racecourse VARCHAR, Distance VARCHAR, Priority-entry-rights to Derby VARCHAR) CREATE TABLE nutritional_content (nutritional_content_id AUTO_INCREMENT PRIMARY KEY, Total fat VARCHAR, Saturated fat VARCHAR, Monounsaturated fat VARCHAR, Polyunsaturated fat VARCHAR, Smoke point VARCHAR) CREATE TABLE historical_premiers (historical_premiers_id AUTO_INCREMENT PRIMARY KEY, Rank: INT, State: VARCHAR, Premier: VARCHAR, Party: VARCHAR, Assumed office: VARCHAR, Left office: VARCHAR, TOTAL Time in office: VARCHAR) CREATE TABLE players_in_the_nba (players_in_the_nba_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, WSU Year(s) VARCHAR, Position VARCHAR, Team VARCHAR, Pro Year(s) VARCHAR) CREATE TABLE assembly_segments (assembly_segments_id AUTO_INCREMENT PRIMARY KEY, Constituency number VARCHAR, Name VARCHAR, Reserved for ( SC / ST /None) VARCHAR, District VARCHAR, Number of electorates (2009) INT)  
SELECT Assumed office: FROM historical_premiers WHERE Premier: = sir charles cowper (1807-1875) kcmg AND Left office: = 2 october 1856