CREATE TABLE table_name_96 (last_match VARCHAR, manner_of_departure VARCHAR, date_of_vacancy VARCHAR)

What is the last match with a resigned manner of departure and a round 1 date of vacancy?
SELECT last_match FROM table_name_96 WHERE manner_of_departure = "resigned" AND date_of_vacancy = "round 1"
SELECT "last_match" FROM "table_name_96" WHERE "date_of_vacancy" = "round 1" AND "manner_of_departure" = "resigned"