what are the characteristic names of "Cumin"?
select t3.characteristic_name from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id join characteristics as t3 on t2.characteristic_id = t3.characteristic_id where t1.product_name = "cumin"
"Cumin" data types
select t3.characteristic_data_type from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id join characteristics as t3 on t2.characteristic_id = t3.characteristic_id where t1.product_name = "cumin"
what is the product id of "cumin"?
select product_id from products where product_name = 'cumin'
what is the product_category_code for product id 1?
select product_category_code from products where product_id = '1'
what is the typical_selling_price of product id 1?
select typical_selling_price from products where product_id = '1'