Table: jersey_express_sports
Columns: year
division
league
regular_season
playoffs
open_cup

Question: What regular season did the team reach the conference semifinals in the playoffs?
SQL: SELECT "regular_season" FROM jersey_express_sports WHERE "playoffs" = 'conference semifinals'

Question: When the regular season of 2nd, Northeast and the year was less than 2008 what was the total number of Division?
SQL: SELECT COUNT("division") FROM jersey_express_sports WHERE "regular_season" = '2nd, northeast' AND "year" < 2008

Question: What division was the regular season 5th, Northeast?
SQL: SELECT "division" FROM jersey_express_sports WHERE "regular_season" = '5th, northeast'