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 é o número total de derrotas nas semifinais para o Kitchener Rangers?
 ###Tabelas: CREATE TABLE active_teams (active_teams_id AUTO_INCREMENT PRIMARY KEY, Tournament Appearances INT, Team VARCHAR, League VARCHAR, Wins INT, Final Losses INT, Semi-Final Losses INT, Fourth-Place* INT, Final Win % VARCHAR, Years of appearance VARCHAR) CREATE TABLE undersecretaries (undersecretaries_id AUTO_INCREMENT PRIMARY KEY, Romanised name VARCHAR, Chinese name VARCHAR, age at appointment INT, Foreign nationality VARCHAR, Portfolio attachment VARCHAR, Govt salary VARCHAR) CREATE TABLE by_country (by_country_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, % of all immigrants 2008 VARCHAR, % of all immigrants 2007 VARCHAR, % of all immigrants 2006 VARCHAR, % of all immigrants 2005 VARCHAR, % of all immigrants 2004 VARCHAR) CREATE TABLE 1860s (1860s_id AUTO_INCREMENT PRIMARY KEY, Year INT, Number of tropical storms INT, Number of hurricanes INT, Number of major hurricanes INT, Deaths VARCHAR, Strongest storm VARCHAR) CREATE TABLE men's_singles (men's_singles_id AUTO_INCREMENT PRIMARY KEY, # INT, Player VARCHAR, Age INT, Australian Open INT, French Open INT, Wimbledon INT, US Open INT)  
SELECT MAX Semi-Final Losses FROM active_teams WHERE Team = Kitchener Rangers