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: Quantas aparições na temporada 3 feitas por Morgan, o cachorro?
 ###Tabelas: CREATE TABLE final_table (final_table_id AUTO_INCREMENT PRIMARY KEY, Position INT, Club VARCHAR, Played INT, Points VARCHAR, Wins INT, Draws INT, Losses INT, Goals for INT, Goals against INT, Goal Difference INT) CREATE TABLE character_appearances (character_appearances_id AUTO_INCREMENT PRIMARY KEY, Character VARCHAR, Played by VARCHAR, Season 1 INT, Season 2 INT, Season 3 INT, Season 4 INT, First Appearance VARCHAR) CREATE TABLE 5801–5900 (5801–5900_id AUTO_INCREMENT PRIMARY KEY, NGC number INT, Object type VARCHAR, Constellation VARCHAR, Right ascension ( J2000 ) VARCHAR, Declination ( J2000 ) VARCHAR) CREATE TABLE the_scotch_arthurs (the_scotch_arthurs_id AUTO_INCREMENT PRIMARY KEY, BR No. INT, SR No. INT, SR Name VARCHAR, Builder VARCHAR, Built VARCHAR, Withdrawn VARCHAR) CREATE TABLE most_goals_in_a_season_—_all_competitions_at_least_40_goals (most_goals_in_a_season_—_all_competitions_at_least_40_goals_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Season VARCHAR, Club VARCHAR, Goals INT, Apps INT, Goals per Match INT)  
SELECT MAX Season 3 FROM character_appearances WHERE Played by = Morgan the Dog