What's the lowest in Votes with a Rank of 5th, has an Occupation of retired, along with a Riding of Brant?
CREATE TABLE "4_seats" (
  "riding" text,
  "candidate_s_name" text,
  "gender" text,
  "residence" text,
  "occupation" text,
  "votes" real,
  "rank" text
);
SELECT MIN("votes") FROM "4_seats" WHERE "rank"='5th' AND "occupation"='retired' AND "riding"='brant';