CREATE TABLE table_name_38 (score VARCHAR2, tie_no VARCHAR2)

what is score of a team with tie of 4?
SELECT score FROM table_name_38 WHERE tie_no = "4"
SELECT "score" FROM "table_name_38" WHERE "4" = "tie_no"