Sold items

Invalid SQL: SELECT itChId, chName, count(itChId) AS cnt FROM items, charities WHERE chId = itChId AND (itDesigner = 'Church's' ) AND (itStatus='ONSALE' OR itStatus='SOLD') GROUP BY chName HAVING cnt > 0 ORDER BY chName