For the Reno Aces, what are the Losses when they had 1 Appearances and a Winning Percentage of 1?
CREATE TABLE table_name_54 (losses INTEGER, team VARCHAR, appearances VARCHAR, winning_percentage VARCHAR)
SELECT SUM(losses) FROM table_name_54 WHERE appearances = 1 AND winning_percentage = 1 AND team = "reno aces"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (losses INTEGER, team VARCHAR, appearances VARCHAR, winning_percentage VARCHAR) Question: For the Reno Aces, what are the Losses when they had 1 Appearances and a Winning Percentage of 1? [/INST] SELECT SUM(losses) FROM table_name_54 WHERE appearances = 1 AND winning_percentage = 1 AND team = "reno aces" </s>