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: Os cavaleiros lutadores têm que tipo de apelido?
 ###Tabelas: CREATE TABLE nhl_goalie_mask_coins (nhl_goalie_mask_coins_id AUTO_INCREMENT PRIMARY KEY, Year INT, Theme VARCHAR, Artist VARCHAR, Mintage INT, Issue Price INT, Special Notes VARCHAR) CREATE TABLE 2004_nfl_draft (2004_nfl_draft_id AUTO_INCREMENT PRIMARY KEY, Round INT, Overall INT, Player VARCHAR, Position VARCHAR, College VARCHAR) CREATE TABLE regional_auditions (regional_auditions_id AUTO_INCREMENT PRIMARY KEY, Episode air date VARCHAR, Audition city VARCHAR, First audition date VARCHAR, Audition venue VARCHAR, Callback audition date VARCHAR, Callback venue VARCHAR, Golden tickets VARCHAR) CREATE TABLE smartphones (smartphones_id AUTO_INCREMENT PRIMARY KEY, Code name VARCHAR, Market name VARCHAR, Platform VARCHAR, Release date VARCHAR, Android version VARCHAR, System on chip VARCHAR, RAM VARCHAR, ROM VARCHAR, Display VARCHAR, Weight VARCHAR, Battery ( mAh ) INT, Bluetooth VARCHAR, Wi-Fi VARCHAR, NFC VARCHAR, Camera VARCHAR, Network VARCHAR) CREATE TABLE current_members (current_members_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Type VARCHAR, Enrollment INT, Nickname VARCHAR, Joined INT)  
SELECT Type FROM current_members WHERE Nickname = Fighting Knights