Table: soccer_seasons
Columns: season
mls_regular_season
mls_cup_playoffs
lamar_hunt_u_s_open_cup
concacaf_champions_cup_concacaf_champions_league

Question: What was the season when mls regular season was 6th, east (9-11-10)?
SQL: SELECT "season" FROM soccer_seasons WHERE "mls_regular_season" = '6th, East (9-11-10)'

Question: What was the mls cup playoffs when concacaf champions cup / concacaf champions league was quarter-finals (09-10)?
SQL: SELECT "mls_cup_playoffs" FROM soccer_seasons WHERE "concacaf_champions_cup_concacaf_champions_league" = 'Quarter-Finals (09-10)'

Question: How many mls cup playoffs where there for the mls regular season is 1st, east* (13-7-10)?
SQL: SELECT COUNT("mls_cup_playoffs") FROM soccer_seasons WHERE "mls_regular_season" = '1st, East* (13-7-10)'

Question: What was the lamar hunt u.s. open cup when concacaf champions cup / concacaf champions league was did not qualify and mls regular season was 4th, central (11-16-5)?
SQL: SELECT "lamar_hunt_u_s_open_cup" FROM soccer_seasons WHERE "concacaf_champions_cup_concacaf_champions_league" = 'Did not qualify' AND "mls_regular_season" = '4th, Central (11-16-5)'

Question: How many entries are there for season where mls regular season was 5th, east (10-12-8)?
SQL: SELECT COUNT("season") FROM soccer_seasons WHERE "mls_regular_season" = '5th, East (10-12-8)'

Question: What was the mls cup playoffs when the mls regular season was 4th, central (11-16-5)?
SQL: SELECT "mls_cup_playoffs" FROM soccer_seasons WHERE "mls_regular_season" = '4th, Central (11-16-5)'