Table: real_colorado_foxes_stats
Columns: year
division
league
regular_season
playoffs
open_cup

Question: How many years did Real Colorado Foxes make it to the Open Cup 1st Round?
SQL: SELECT COUNT("year") FROM real_colorado_foxes_stats WHERE "open_cup" = '1st round'

Question: When is the latest year that Real Colorado Foxes did not qualify for the playoffs but make it to Open Cup 2nd Round?
SQL: SELECT MAX("year") FROM real_colorado_foxes_stats WHERE "playoffs" = 'did not qualify' AND "open_cup" = '2nd round'

Question: In 2012, which round in the Open Cup did Real Colorado Foxes make it to the conference semifinal?
SQL: SELECT "open_cup" FROM real_colorado_foxes_stats WHERE "playoffs" = 'conference semifinal' AND "year" = 2012