CREATE TABLE table_name_90 (award VARCHAR2, year VARCHAR2, category VARCHAR2)

Who was awarded after 1947 in the category of, the best actor in a leading role?
SELECT award FROM table_name_90 WHERE year > 1947 AND category = "best actor in a leading role"
SELECT "award" FROM "table_name_90" WHERE "best actor in a leading role" = "category" AND "year" > 1947