CREATE TABLE table_name_40 (res VARCHAR2, event VARCHAR2)

Which Res has an Event of UFC 122?
SELECT res FROM table_name_40 WHERE event = "ufc 122"
SELECT "res" FROM "table_name_40" WHERE "event" = "ufc 122"