CREATE TABLE table_name_47 (score VARCHAR2, tie_no VARCHAR2)

What is the score when the tie number is 4?
SELECT score FROM table_name_47 WHERE tie_no = "4"
SELECT "score" FROM "table_name_47" WHERE "4" = "tie_no"