Table: cougar_stats
Columns: year
league
reg_season
playoffs
avg_attendance

Question: What regular season result had an average attendance less than 942?
SQL: SELECT "reg_season" FROM cougar_stats WHERE "avg_attendance" < 942

Question: Which league had a playoffs result of a lost semifinal?
SQL: SELECT "league" FROM cougar_stats WHERE "playoffs" = 'lost semifinal'