question: What's the lowest in Votes with a Rank of 5th, has an Occupation of retired, along with a Riding of Brant?
answer: SELECT MIN(votes) FROM table_name_97 WHERE rank = "5th" AND occupation = "retired" AND riding = "brant"
context: CREATE TABLE table_name_97 (votes INTEGER, riding VARCHAR, rank VARCHAR, occupation VARCHAR)