user: Question: What was the Attendance during the home game where st. johnstone was the Opponent?
Columns: ['Date', 'Opponent', 'Venue', 'Result (Celtic score first)', 'Attendance', 'Match report']
Types: ['text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['30 July 2000 – 18:05', 'Dundee United', 'Away', '2–1', 11761.0, 'BBC Sport']
SQL:

assistant: SELECT "Attendance" FROM "Table" WHERE "Opponent" = 'st. johnstone' AND "Venue" = 'home';