SELECT
    A.FirstName,
    A.LastName,
    A.EmployeeID,
    COALESCE(C.PhonesToday,0) AS PhonesToday,
    AVG(B.AvgTimePerPhone) AS AvgTimePerPhone,
    AVG(B.PhonesPerDay) AS AvgPhonesPerDay
FROM
    (
        EmployeeTable AS A
        INNER JOIN
        (
            SELECT
                A.EmployeeID,
                AVG(A.Timer) AS AvgTimePerPhone,
                COUNT(DISTINCT A.InventoryID) AS PhonesPerDay,
                DATEADD(dd,0, DATEDIFF(dd,0,A.ReceiveDate)) AS ReceiveDate
            FROM
                InventoryTable AS A
            GROUP BY
                A.EmployeeID,
                ReceiveDate
        ) AS B
        ON A.EmployeeID = B.EmployeeID
    )
    LEFT JOIN
    (
        SELECT
            A.EmployeeID,
            COUNT(A.InventoryID) AS PhonesToday
        FROM
            InventoryTable AS A
        WHERE
            DATEADD(dd,0, DATEDIFF(dd,0,A.ReceiveDate)) = DATEADD(dd,0,DATEDIFF(dd,0,GETDATE()))
        GROUP BY
            A.EmployeeID
    ) AS C
    ON A.EmployeeID = C.EmployeeID
GROUP BY
    A.FirstName,
    A.LastName,
    A.EmployeeID,
    PhonesToday