Table: soccer_team_stats_5
Columns: year
division
league
reg_season
playoffs
open_cup
avg_attendance

Question: What division has finalist playoffs and was 3rd round Open Cup?
SQL: SELECT "division" FROM soccer_team_stats_5 WHERE "playoffs" = 'finalist' AND "open_cup" = '3rd round'

Question: What year was the team 8th in the season and made it to the 3rd round in Open Cup?
SQL: SELECT "year" FROM soccer_team_stats_5 WHERE "reg_season" = '8th' AND "open_cup" = '3rd round'