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: Quantos episódios foram intitulados "O melhor amigo do homem"?
 ###Tabelas: CREATE TABLE practice_times__&__leaderboard_superstock_tt (practice_times__&__leaderboard_superstock_tt_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Rider VARCHAR, Sat 29 May VARCHAR, Mon 31 May VARCHAR, Tues 1 June VARCHAR, Wed 2 June VARCHAR, Thurs 3 June VARCHAR, Fri 4 June VARCHAR) CREATE TABLE highest_partnerships_for_each_wicket (highest_partnerships_for_each_wicket_id AUTO_INCREMENT PRIMARY KEY, Wicket VARCHAR, Runs VARCHAR, Partnerships VARCHAR, Venue VARCHAR, Date VARCHAR) CREATE TABLE season_2_1995–1996 (season_2_1995–1996_id AUTO_INCREMENT PRIMARY KEY, Series # INT, Season # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Musical guest and song VARCHAR, Original air date VARCHAR, Production code VARCHAR) CREATE TABLE regular_home_and_away_season (regular_home_and_away_season_id AUTO_INCREMENT PRIMARY KEY, Round INT, Date VARCHAR, Opponent VARCHAR, Home/Away VARCHAR, Score (Collingwoods score is in bold) VARCHAR, Result (includes margin) VARCHAR, Venue VARCHAR, Position on Ladder VARCHAR) CREATE TABLE top_ten_medals (top_ten_medals_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Province VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT)  
SELECT COUNT Directed by FROM season_2_1995–1996 WHERE Title = "Man's Best Friend"