Find the number of characteristics that the product "caraway" has.
SELECT count ( * )  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  =  "caraway"
number of characteristics for product 'caraway' refers to COUNT(*) of joined rows from products and product_characteristics tables where product_name = 'caraway';