CREATE TABLE table_name_92 (team VARCHAR, rank VARCHAR, rider VARCHAR)

What team has a Rank Ret, and rider Frank A Applebee?
SELECT team FROM table_name_92 WHERE rank = "ret" AND rider = "frank a applebee"
SELECT "team" FROM "table_name_92" WHERE "frank a applebee" = "rider" AND "rank" = "ret"