select AVG(project_stars),tm from (
select project_stars, DATEPART(day, DATEADD(d, cast( create_time/1000/3600/24 as int),'1970-01-01 08:00')) tm from assessment ) t
group by t.tm
select project_stars, DATEPART(day, DATEADD(d, cast( create_time/1000/3600/24 as int),'1970-01-01 08:00')) tm from assessment ) t
group by t.tm