Table: nysoccer_stats
Columns: year
division
league
regular_season
playoffs
open_cup

Question: What was the team's playoff status in 2011?
SQL: SELECT "playoffs" FROM nysoccer_stats WHERE "year" = '2011'

Question: What was the team's league in 2010?
SQL: SELECT "league" FROM nysoccer_stats WHERE "year" = '2010'

Question: What is the league name for the regular season status of 2nd, mid atlantic?
SQL: SELECT "league" FROM nysoccer_stats WHERE "regular_season" = '2nd, Mid Atlantic'