Database: bakery_1
Question: Find all the items that have chocolate flavor but were not bought more than 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