CREATE TABLE table_74300 ("For shank type" CLOB, "Singer part number" CLOB, "Uses templates?" CLOB, "Description" CLOB, "Storage case" CLOB)

What's the singer part number of the buttonholer whose storage case is a green plastic box?
SELECT "Singer part number" FROM table_74300 WHERE "Storage case" = 'green plastic box'
SELECT "Singer part number" FROM "table_74300" WHERE "Storage case" = 'green plastic box'