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 novo total de membros se os membros perdidos forem maiores que 1.0?
 ###Tabelas: 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 senior_major_winners (senior_major_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, Senior PGA Championship VARCHAR, The Tradition VARCHAR, Senior Players Championship VARCHAR, U.S. Senior Open VARCHAR, Senior British Open VARCHAR) CREATE TABLE broadcast_rights (broadcast_rights_id AUTO_INCREMENT PRIMARY KEY, Territory VARCHAR, Broadcaster VARCHAR, Channel INT, Launched VARCHAR, Closed VARCHAR) CREATE TABLE sheffield_united_statistics (sheffield_united_statistics_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Division VARCHAR, League Apps INT, League Goals INT, FA Cup Apps INT, FA Cup Goals INT, Other Apps INT, Other Goals INT, Total Apps INT, Total Goals INT) CREATE TABLE west_conference (west_conference_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Affiliation VARCHAR, Enrollment INT, Nickname VARCHAR)  
SELECT MAX New membership total FROM ice_hockey WHERE Members lost > 1.0