WITH CallStats
AS (
SELECT EmployeeID, AuditDate, AVG(Timer) AS AvgTimePerPhone, COUNT(1) AS PhonesPerDay
FROM AuditTable
GROUP BY
EmployeeID, AuditDate
),
TodayCalls AS
(
SELECT EmployeeID, COUNT(1) AS PhonesToday
FROM AuditTable
WHERE AuditDate = GETDATE()
GROUP BY
EmployeeID

)

SELECT E.FirstName, E.LastName, COALESCE(AvgTimePerPhone, 0.00) AS AvgTimePerPhone , COALESCE(PhonesPerDay,0) AS PhonesPerDay, COALESCE(TodayCalls,0) AS TodayCalls
FROM EmployeeTable AS E
LEFT OUTER JOIN CallStats
ON E.EmployeeID = CallStats.EmployeeID
LEFT OUTER JOIN TodayCalls
ON E.EmployeeID = TodayCalls.EmployeeID