SQL 0 if negative value December 9, 2023 by Tarik An alternate approach you could use is the GREATEST() function. SUM(GREATEST(ordered_item.amount, 0)) as purchases