CREATE TABLE product_characteristics (product_id VARCHAR2)
CREATE TABLE products (product_id VARCHAR2, product_name VARCHAR2)

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"
SELECT COUNT(*) FROM "products" "t1" JOIN "product_characteristics" "t2" ON "t1"."product_id" = "t2"."product_id" WHERE "sesame" = "t1"."product_name"