SQL - MULTIPLE COUNT OR SUM CASE WHEN

Multiple COUNT 

SELECT Approved  = (SELECT COUNT(*) FROM dbo.Claims d

                    WHERE d.Status = 'Approved'),

        Valid    = (SELECT COUNT(*) FROM dbo.Claims d

                    WHERE d.Status = 'Valid'),

        Reject   = (SELECT COUNT(*) FROM dbo.Claims d

                    WHERE d.Status = 'Reject')

SUM CASE WHEN

SELECT  Approved = SUM(CASE WHEN Status = 'Approved' THEN 1 ELSE 0 END),

        Valid    = SUM(CASE WHEN Status = 'Valid'    THEN 1 ELSE 0 END),

        Reject   = SUM(CASE WHEN Status = 'Reject'   THEN 1 ELSE 0 END)

FROM dbo.Claims c;

SELECT  Approved = SUM(CASE WHEN Status = 'Approved' THEN 1 ELSE 0 END),

        Valid    = SUM(CASE WHEN Status = 'Valid'    THEN 1 ELSE 0 END),

        Reject   = SUM(CASE WHEN Status = 'Reject'   THEN 1 ELSE 0 END)

FROM dbo.Claims c

WHERE  c.Status = 'Approved'

    OR c.Status = 'Valid'

    OR c.Status = 'Reject';