Table: scrhl_game_results
Columns: year
champion
score
runner_up
location
semi_finalist_1
semi_finalist_2

Question: Which team was the second semi finalist in 2007?
SQL: SELECT "semi_finalist_2" FROM scrhl_game_results WHERE "year" = 2007

Question: How many teams were listed as runner up in 2005 and there the first semi finalist was Western Carolina?
SQL: SELECT COUNT("runner_up") FROM scrhl_game_results WHERE "semi_finalist_1" = 'Western Carolina' AND "year" = 2005

Question: List the scores of all games when Miami were listed as the first Semi finalist
SQL: SELECT "score" FROM scrhl_game_results WHERE "semi_finalist_1" = 'Miami'

Question: When Embry-Riddle made it to the first semi finalist slot, list all the runners up.
SQL: SELECT "runner_up" FROM scrhl_game_results WHERE "semi_finalist_1" = 'Embry-Riddle'

Question: Where was the final game played in 2007
SQL: SELECT "location" FROM scrhl_game_results WHERE "year" = 2007