Table: player_stats_84
Columns: name
years
mls_cup
u_s_open_cup
concacaf
other
total

Question: How many Totals have a CONCACAF of 0, and an MLS Cup smaller than 6?
SQL: SELECT COUNT("total") FROM player_stats_84 WHERE "concacaf" = 0 AND "mls_cup" < 6

Question: Which MLS Cup has another larger than 9, and a Total smaller than 72?
SQL: SELECT AVG("mls_cup") FROM player_stats_84 WHERE "other" > 9 AND "total" < 72