CREATE TABLE table_name_23 (semifinalists VARCHAR2, finalist VARCHAR2)

Which Semifinalists has a Finalist of andre agassi?
SELECT semifinalists FROM table_name_23 WHERE finalist = "andre agassi"
SELECT "semifinalists" FROM "table_name_23" WHERE "andre agassi" = "finalist"