what are the characteristics of the product name 'sesame'?
select t2.characteristic_id from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id where t1.product_name = "sesame"
how many characteristics does the product name 'sesame' have?
select count ( * ) from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id where t1.product_name = "sesame"
what is the product category code for product name 'sesame'
select product_category_code from products where product_name = 'sesame'
what is the product characteristic value for product name 'sesame'
select t2.product_characteristic_value from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id where t1.product_name = "sesame"