Table: canadian_uni_soccer_teams
Columns: university
varsity_name
city
province
founded
soccer_stadium
stadium_capacity

Question: What is the name of the soccer stadium in NL providence?
SQL: SELECT "soccer_stadium" FROM canadian_uni_soccer_teams WHERE "province" = 'NL'

Question: which providence's soccer stadium was founded in 2005?
SQL: SELECT "province" FROM canadian_uni_soccer_teams WHERE "founded" = 2005

Question: What is the team mascot for the soccer team in Charlottetown?
SQL: SELECT "varsity_name" FROM canadian_uni_soccer_teams WHERE "city" = 'Charlottetown'

Question: Which province has the soccer stadium that holds 4,000 people?
SQL: SELECT "province" FROM canadian_uni_soccer_teams WHERE "stadium_capacity" = '4,000'

Question: Which University's soccer stadium in named Moncton Stadium?
SQL: SELECT "university" FROM canadian_uni_soccer_teams WHERE "soccer_stadium" = 'Moncton Stadium'