assignment theodbs

SELECT DISTINCT T.name as Item I.name as Ingredients

From madewith as M, ingredients as I, items as T

Where (M.itemid = T.itemid)

And (M.ingredientid = I.ingredientid)

And ((quantity * 3) > inventory)