What is the selling price of the product named "sesame"?
select typical_selling_price from products where product_name = "sesame"
What is its color?
select t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "sesame"
What are its product characteristic values?
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"
Count how many there are.
select count(*) from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id where t1.product_name = "sesame"