Table: soccer_stats_3
Columns: rank
player
nation
assist
games
years

Question: How many games had an assist number greater than 54?
SQL: SELECT SUM("games") FROM soccer_stats_3 WHERE "assist" > 54

Question: Which years did the USA have a rank lower than 6 and an assist number less than 26?
SQL: SELECT "years" FROM soccer_stats_3 WHERE "assist" < 26 AND "rank" < 6 AND "nation" = 'usa'

Question: Which year or years did a team win 174 games and had an assist number less than 17?
SQL: SELECT "years" FROM soccer_stats_3 WHERE "assist" < 17 AND "games" = 174