CREATE TABLE table_name_97 (lead VARCHAR2, third VARCHAR2)

Who holds the lead role when Aanders Brorson is third?
SELECT lead FROM table_name_97 WHERE third = "aanders brorson"
SELECT "lead" FROM "table_name_97" WHERE "aanders brorson" = "third"