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 era o novo total de membros na conferência nchc (apenas homens)?
 ###Tabelas: CREATE TABLE doubles_8–10 (doubles_8–10_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponent in the final VARCHAR, Score VARCHAR) CREATE TABLE club_and_player_records (club_and_player_records_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Opponent VARCHAR, Score VARCHAR, Venue VARCHAR, Round VARCHAR) CREATE TABLE ice_hockey (ice_hockey_id AUTO_INCREMENT PRIMARY KEY, Conference VARCHAR, Old membership total INT, New membership total INT, Net change VARCHAR, Members added INT, Members lost INT) CREATE TABLE passenger_and_express_train_locomotives (passenger_and_express_train_locomotives_id AUTO_INCREMENT PRIMARY KEY, Class VARCHAR, Railway number(s) VARCHAR, DRG number(s) VARCHAR, Quantity INT, Year(s) of manufacture VARCHAR, Axle arrangement VARCHAR) CREATE TABLE final_standing (final_standing_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Games Played INT, Wins INT, Losses INT, Ties INT, Goals For INT, Goals Against INT)  
SELECT New membership total FROM ice_hockey WHERE Conference = NCHC (men only)