What are the selling prices of the products?
select typical_selling_price from products
What about for those that have product characteristic value "high"?
select t1.typical_selling_price from products as t1 join product_characteristics as t2 on t1.product_id = t2.product_id where t2.product_characteristic_value = "high"
What about for those that have characteristic type code "Grade"?
select t1.typical_selling_price 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 t3.characteristic_type_code = "Grade"
Of those, filter down to those that are product name "sesame" as well.
select t1.typical_selling_price 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 = "sesame" and t3.characteristic_type_code = "Grade"
Give the characteristic names instead.
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 = "sesame" and t3.characteristic_type_code = "Grade"