Assignment

SELECT DISTINCT im.name as item, i.name as ingredient

FROM ingredients as i, items as im, madewith as mw,

WHERE i.ingredientid = mw.ingredientid AND im.itemid = mw.itemid AND quantity * 3 > inventory