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

Question:  who is the champion where semi-finalist #2 is na and location is morrisville, nc
SQL: SELECT "champion" FROM scrhl_games WHERE "semi_finalist_2" = 'NA' AND "location" = 'Morrisville, NC'

Question:  what's the score where year is 2007
SQL: SELECT "score" FROM scrhl_games WHERE "year" = '2007'

Question: what is the total number of semi-finalist #2 where runner-up is east carolina
SQL: SELECT COUNT("semi_finalist_2") FROM scrhl_games WHERE "runner_up" = 'East Carolina'

Question:  who is the semi-finalist #1 where runner-up is elon university
SQL: SELECT "semi_finalist_1" FROM scrhl_games WHERE "runner_up" = 'Elon University'

Question:  who is the runner-up where year is 2004 and champion is north carolina state
SQL: SELECT "runner_up" FROM scrhl_games WHERE "year" = '2004' AND "champion" = 'North Carolina State'

Question:  who is the runner-up where location is ellenton, fl and year is 2004
SQL: SELECT "runner_up" FROM scrhl_games WHERE "location" = 'Ellenton, FL' AND "year" = '2004'