CREATE TABLE table_name_97 (votes INT, riding VARCHAR, rank VARCHAR, occupation VARCHAR)

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