Task: Text to Code
Input (English): How many characteristics does the product named "sesame" have?
Output (English): SELECT count(*) FROM products AS t1 JOIN product_characteristics AS t2 ON t1.product_id  =  t2.product_id WHERE t1.product_name  =  "sesame"