medium10 pts · first answer countssqlnull-handling

SUM over zero matching rows

No orders exist for the region 'Fujairah'. What does this query return, and how do you make it show 0?

SELECT SUM(amount) FROM orders WHERE region = 'Fujairah';

A.It returns 0, so nothing needs to changeB.It returns no rows; add GROUP BY regionC.It raises an error; add a TRY blockD.It returns one row with NULL; wrap it as COALESCE(SUM(amount), 0)

← Shaping a Power BI model Take the medium mock interview →