SELECT AVG(completed_count) AS avg_daily_completed, COUNT(*) AS days_with_completion
FROM (
SELECT
DATEADD(DAY, DATEDIFF(DAY, 0, create_date), 0) AS create_day,
COUNT(*) AS completed_count
FROM dbo.table_name
WHERE status = 'completed' AND
create_date >= '20190101' AND create_date < '20200101'
GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, create_date), 0)
) AS query1
Open in new window