Table: shank_details
Columns: for_shank_type
singer_part_number
uses_templates
description
storage_case

Question: What's the singer part number of the buttonholer whose storage case is a green plastic box?
SQL: SELECT "singer_part_number" FROM shank_details WHERE "storage_case" = 'green plastic box'

Question: What's the description of the buttonholer whose singer part number is 121795 kit 121908 buttonholer?
SQL: SELECT "description" FROM shank_details WHERE "singer_part_number" = '121795 kit 121908 buttonholer'

Question: What are all the different descriptions for the buttonholer with cardboard box for storage and a low shank type?
SQL: SELECT "description" FROM shank_details WHERE "storage_case" = 'cardboard box' AND "for_shank_type" = 'low'

Question: What's the storage case of the buttonholer described as ivory and red metal?
SQL: SELECT "storage_case" FROM shank_details WHERE "description" = 'ivory and red metal'

Question: What's the shank type of the buttonholer with red plastic box as storage case?
SQL: SELECT "for_shank_type" FROM shank_details WHERE "storage_case" = 'red plastic box'