CREATE TABLE table_26485957_1 (artist VARCHAR2, result VARCHAR2)

Which artist had a result of 4?
SELECT artist FROM table_26485957_1 WHERE result = "4"
SELECT "artist" FROM "table_26485957_1" WHERE "4" = "result"