you can do this without the WITH clause as below.

SELECT 
COUNT(Id) AS Total,
COUNT(CASE WHEN Updated IS NULL THEN 1 END) AS NotUpdated,
COUNT(CASE WHEN Updated IS NOT NULL THEN 1 END) AS Updated
FROM BatchHeaders;