user: ### NOW ANSWER:
Question: What is the lowest ranking seating capacity smaller than 7485, and a stadium at St. Colman's Park?
Columns: ['Rank', 'Stadium', 'Total Capacity', 'Seating Capacity', 'Location']
Types: ['real', 'text', 'text', 'real', 'text']
Sample row: [1.0, 'Aviva Stadium', '51,700', 51700.0, 'Ballsbridge , Dublin']
SQL:

assistant: SELECT MIN("Rank") FROM "Table" WHERE "Seating Capacity" < 7485.0 AND "Stadium" = 'St. Colman''s Park';