How many characteristics does the product named "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 are the characteristic ids of those? Sorry!
select characteristic_id from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id where t1.product_name = "sesame"
What is sesame's typical selling price?
select typical_selling_price from products where product_name = "sesame"
What the most common characteristic id?
select characteristic_id from product_characteristics group by characteristic_id order by count ( * ) desc limit 1
What is the least common product category code?
select product_category_code from products group by product_category_code order by count ( * ) limit 1