Table: scottish_first_division_stats
Columns: team
stadium
capacity
highest
lowest
average

Question: What is the lowest attendance that East End Park has ever had?
SQL: SELECT MIN("lowest") FROM scottish_first_division_stats WHERE "stadium" = 'East End Park'

Question: What team plays at Palmerston Park?
SQL: SELECT "team" FROM scottish_first_division_stats WHERE "stadium" = 'Palmerston Park'

Question: What is the lowest attandance recorded at Cappielow?
SQL: SELECT MIN("lowest") FROM scottish_first_division_stats WHERE "stadium" = 'Cappielow'

Question: What is the highest attendance at a game played by St. Johnstone?
SQL: SELECT MAX("highest") FROM scottish_first_division_stats WHERE "team" = 'St. Johnstone'

Question: What is the highest attandence at a Hamilton Academical game?
SQL: SELECT MIN("highest") FROM scottish_first_division_stats WHERE "team" = 'Hamilton Academical'