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: Qual é a Segunda Especialidade Militar de Gareth Morgan?
 ###Tabelas: CREATE TABLE doubles:_11_1–10 (doubles:_11_1–10_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE highest_first_week_sales (highest_first_week_sales_id AUTO_INCREMENT PRIMARY KEY, Number INT, Artist VARCHAR, Album VARCHAR, 1st week sales INT, 1st week position VARCHAR) CREATE TABLE 1985_nfl_draft (1985_nfl_draft_id AUTO_INCREMENT PRIMARY KEY, Round INT, Pick INT, Name VARCHAR, Position VARCHAR, School VARCHAR) CREATE TABLE composition_of_the_17th_seanad (composition_of_the_17th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE characters (characters_id AUTO_INCREMENT PRIMARY KEY, Code Name VARCHAR, Function (figure) VARCHAR, Real Name VARCHAR, Birthplace VARCHAR, Serial number VARCHAR, Primary military speciality VARCHAR, Secondary military speciality VARCHAR, Equipment VARCHAR)  
SELECT Secondary military speciality FROM characters WHERE Real Name = gareth morgan