Table: scot_prem_league_stats
Columns: team
stadium
capacity
lowest
highest
average

Question: What is the minimum capacity of Dundee United's stadium?
SQL: SELECT MIN("capacity") FROM scot_prem_league_stats WHERE "team" = 'Dundee United'

Question: Which stadiums have a capacity of 51082?
SQL: SELECT "stadium" FROM scot_prem_league_stats WHERE "capacity" = 51082

Question: How many stadiums are there with a capacity of 7500?
SQL: SELECT COUNT("stadium") FROM scot_prem_league_stats WHERE "capacity" = 7500

Question: What is Pittodrie Stadium's maximum capacity?
SQL: SELECT MAX("capacity") FROM scot_prem_league_stats WHERE "stadium" = 'Pittodrie'

Question: Which stadiums have an average attendance of 13840?
SQL: SELECT "stadium" FROM scot_prem_league_stats WHERE "average" = 13840

Question: What are the highest recorded attendance rates of the stadiums with an average attendance of 4752?
SQL: SELECT "highest" FROM scot_prem_league_stats WHERE "average" = 4752