SELECT g.[GROUP Name], [Today] = ISNULL(t1.[Today], 0), [Week] = ISNULL(t2.[Week], 0), [Month] = ISNULL(t3.[Month], 0)
FROM _SMDBA_.[Groups] g
    LEFT OUTER JOIN
    (
        SELECT  [GROUP Name], COUNT( [WORK ORDER #] ) AS Today
        FROM    _SMDBA_.[WORK Orders]
        WHERE   [OPEN DATE & TIME] <= GETDATE() AND [OPEN DATE & TIME] >= CAST( GETDATE() AS DATE) AND [GROUP Name] IN ('CS LOGISTICS', 'CS HELPDESK', 'CS LEAD', 'CS FT RESEARCH', 'CS EI RESEARCH', 'CS MANAGEMENT')
        GROUP BY        [GROUP Name]
    ) t1 ON g.[GROUP Name] = t1.[GROUP Name]
    LEFT OUTER JOIN
    (
        SELECT  [GROUP Name], COUNT( [WORK ORDER #] ) AS Week
        FROM    _SMDBA_.[WORK Orders]
        WHERE   [OPEN DATE & TIME] <= GETDATE() AND [OPEN DATE & TIME] >= CAST(DATEADD([week], - 1, GETDATE()) AS DATE) AND [GROUP Name] IN ('CS LOGISTICS', 'CS HELPDESK', 'CS LEAD', 'CS FT RESEARCH', 'CS EI RESEARCH', 'CS MANAGEMENT')
        GROUP BY        [GROUP Name]
    ) t2 ON g.[GROUP Name] = t2.[GROUP Name]
    LEFT OUTER JOIN
    (
        SELECT  [GROUP Name], COUNT( [WORK ORDER #] ) AS MONTH
        FROM    _SMDBA_.[WORK Orders]
        WHERE   [OPEN DATE & TIME] <= GETDATE() AND [OPEN DATE & TIME] >= CAST(DATEADD([MONTH], - 1, GETDATE()) AS DATE) AND [GROUP Name] IN ('CS LOGISTICS', 'CS HELPDESK', 'CS LEAD', 'CS FT RESEARCH', 'CS EI RESEARCH', 'CS MANAGEMENT')
        GROUP BY        [GROUP Name]
    ) t3 ON g.[GROUP Name] = t3.[GROUP Name]
ORDER BY g.[GROUP Name]