4 ms·'HAVING sum(coalesce(o.price, 0)) < 100'by pjot 7y ago'HAVING sum(coalesce(o.price, 0)) < 100'jeffdavis 7y agoYou are correct. The coalesce can go inside or outside the SUM().