Table: sports_venues_charlotte
Columns: venue
location
capacity
owner
environment
year_built

Question: What year was John m. Belk Arena built?
SQL: SELECT "year_built" FROM sports_venues_charlotte WHERE "venue" = 'john m. belk arena'

Question: What type of environment is the venue that was built in 2003?
SQL: SELECT "environment" FROM sports_venues_charlotte WHERE "year_built" = '2003'

Question: What year was transamerica field built in?
SQL: SELECT "year_built" FROM sports_venues_charlotte WHERE "venue" = 'transamerica field'

Question: What is the location of the venue owned by johnson c. smith university?
SQL: SELECT "location" FROM sports_venues_charlotte WHERE "owner" = 'johnson c. smith university'