What is the lowest ranking seating capacity smaller than 7,485, and a stadium at St. Colman's Park?
CREATE TABLE "stadiums" (
  "rank" real,
  "stadium" text,
  "total_capacity" text,
  "seating_capacity" real,
  "location" text
);
SELECT MIN("rank") FROM "stadiums" WHERE "seating_capacity"<'7,485' AND "stadium"='st. colman''s park';