Database: bakery_1
Question: What are the items with chocolate flavor that were purchased at most 10 times.
SQL:
SELECT DISTINCT T1.item FROM items AS T1 JOIN goods AS T2 ON T1.item  =  T2.id WHERE T2.flavor  =  "Chocolate" GROUP BY item HAVING count(*)  <=  10