CREATE TABLE table_name_4 (category VARCHAR2, finish VARCHAR2)

Which category had an orange finish?
SELECT category FROM table_name_4 WHERE finish = "orange"
SELECT "category" FROM "table_name_4" WHERE "finish" = "orange"