COUNT på flere feldter med GROUP BY.

SELECT
    HOUR(CreatedDT) AS Timme,
    COUNT(*) AS CreatedDT,
    (SELECT
            COUNT(*)
        FROM
            ProductAppToDo
        WHERE
            CompletedDT > curdate()
                AND CompletedDT <> 0) AS CompletedDT,
    (SELECT
            COUNT(*)
        FROM
            ProductAppToDo
        WHERE
            PausedDT > curdate() AND PausedDT <> 0) AS PausedDT,
    (SELECT
            COUNT(*)
        FROM
            ProductAppToDo
        WHERE
            AssignedDT > curdate()
                AND AssignedDT <> 0) AS AssignedDT
FROM
    ProductAppToDo
WHERE
    CreatedDT > CURDATE()
GROUP BY HOUR(CreatedDT)

SELECT
    DAYOFWEEK(CreatedDT) AS Dag,
    WEEK(CreatedDT) AS Vecka,
    HOUR(CreatedDT) AS Timme,
    COUNT(*) AS 'Antal ansökningar',
    COALESCE(SUM(CompletedDT <> 0), 0) AS Sökta,
    COALESCE(SUM(PausedDT <> 0), 0) AS Pausad,
    COALESCE(SUM(AssignedDT <> 0), 0) AS Utdelad,
    COALESCE(SUM(AssignedDT = 0), 0) AS Kvarvarande
FROM
    ProductAppToDo
WHERE
    CreatedDT > CURDATE()
GROUP BY HOUR(CreatedDT)