Table: coach_stats_2
Columns: season
wins
losses
ties
ivy_lg_record

Question: What is the highest value for Ties, when Losses is less than 8?
SQL: SELECT MAX("ties") FROM coach_stats_2 WHERE "losses" < 8

Question: What is the total number of Losses, when Ties is 2, and when Wins is greater than 8?
SQL: SELECT COUNT("losses") FROM coach_stats_2 WHERE "ties" = 2 AND "wins" > 8