MODERN DASHBOARD | Return COUNT null as zero in KPI widget

I'm fairly new to SWQL and SQL. Im having a hard time to make this swql query work. 

SELECT COUNT(1) as Count_Items, a.Status
FROM Orion.APM.Application a

JOIN Orion.Nodes n
ON n.NodeID = a.NodeID

WHERE Status = 14 AND n.CustomProperties.Device_Prio LIKE 'Prio1%'
GROUP BY a.Status

This counts the critical applications with a custom property. To make it more presentable I would like to show it as zero when null is returned instead of blank in the widget. Thank in advance!