Table: odac_schools
Columns: institution
location
nickname
founded
type
enrollment
football
joined

Question: What is every type for the location of Roanoke, Virginia?
SQL: SELECT "type" FROM odac_schools WHERE "location" = 'Roanoke, Virginia'

Question: How many values for joined occur at Guilford College?
SQL: SELECT COUNT("joined") FROM odac_schools WHERE "institution" = 'Guilford College'

Question: What is every institution with the nickname of Quakers?
SQL: SELECT "institution" FROM odac_schools WHERE "nickname" = 'Quakers'

Question: What is every entry for football when enrollment is 998?
SQL: SELECT "football" FROM odac_schools WHERE "enrollment" = 998

Question: What is the least value of joined?
SQL: SELECT MIN("joined") FROM odac_schools

Question: What is every institution with the nickname of Wildcats?
SQL: SELECT "institution" FROM odac_schools WHERE "nickname" = 'WildCats'