Table: harrisburg_islanders_stats
Columns: year
division
league
regular_season
playoffs
u_s_open_cup
avg_attendance

Question: What league has an average attendance of 1452?
SQL: SELECT "league" FROM harrisburg_islanders_stats WHERE "avg_attendance" = 1452

Question: What year at the US Open Cup quarterfinals, were the playoffs in the semifinals for the USL second division?
SQL: SELECT "year" FROM harrisburg_islanders_stats WHERE "league" = 'USL Second Division' AND "playoffs" = 'Semifinals' AND "u_s_open_cup" = 'Quarterfinals'