Fishbowl Query: All Product Inventory

SELECT PART.NUM AS "Part Number", PART.STDCOST AS "Cost", PART.DATELASTMODIFIED AS "Last Modified Date", COALESCE(SUM(COALESCE(QTYINVENTORYTOTALS.QTYONHAND, 0) - COALESCE(QTYINVENTORYTOTALS.QTYALLOCATED, 0) - COALESCE(QTYINVENTORYTOTALS.QTYNOTAVAILABLE, 0) + COALESCE(QTYINVENTORYTOTALS.QTYDROPSHIP, 0)), 0) AS "Available"
FROM PART
LEFT JOIN QTYINVENTORYTOTALS ON PART.ID = QTYINVENTORYTOTALS.PARTID
WHERE PART.TYPEID = 10
GROUP BY PART.ID, PART.NUM, PART.STDCOST, PART.DATELASTMODIFIED
ORDER BY PART.NUM;