assignment in THEODBS

SELECT DISTINCT [it.name] as Item i.name as Ingredients
From madewith as mw, ingredients as i, items as it
Where (mw.itemid = it.itemid)
And (mw.ingredientid = i.ingredientid)
And ((quantity * 3) > inventory);