Table: hockey_schools
Columns: school
location
founded
affiliation
nickname

Question: Who is affiliated with the Dukes?
SQL: SELECT "affiliation" FROM hockey_schools WHERE "nickname" = 'dukes'

Question: What school is in Radford, Va?
SQL: SELECT "school" FROM hockey_schools WHERE "location" = 'radford, va'

Question: What school has a public nickname, founded after 1838 in Harrisonburg, Va?
SQL: SELECT "nickname" FROM hockey_schools WHERE "affiliation" = 'public' AND "founded" > 1838 AND "location" = 'harrisonburg, va'