CREATE TABLE table_name_82 (quantity NUMBER, designation VARCHAR2)

Which Quantity has a Designation of type 4?
SELECT AVG(quantity) FROM table_name_82 WHERE designation = "type 4"
SELECT AVG("quantity") FROM "table_name_82" WHERE "designation" = "type 4"