CREATE TABLE table_name_94 (rank INT, location VARCHAR)

What was the highest rink for Kingston?
SELECT MAX(rank) FROM table_name_94 WHERE location = "kingston"
SELECT MAX("rank") FROM "table_name_94" WHERE "kingston" = "location"