没数据也要显示

SET DATEFIRST 1--设置星期一为每周的开始
select
   case
   when tt.dayOnweek='星期天' then '周日'
   else replace(tt.dayOnweek,'星期','周')
   end as dayOnweek,ISNULL(tt.RYCount,0) as RYCount from
(
   select
dayOnweek,
   count(RYCount) as RYCount from(
       select
       MineName,
       datename(Weekday,DownWellTime) as dayOnweek,
       count(WorkNumber) as RYCount
       from [GL_RYDW_MonthCheckRecord202006]
       where DATEDIFF(WK,DATEADD(DD,-@@DATEFIRST,GETDATE()),DATEADD(DD,-@@DATEFIRST,DownWellTime))=0
       group by DownWellTime,WorkNumber,MineName
   )as t
group by t.dayOnweek,t.RYCount
)as tt
order by charindex(substring(tt.dayOnweek,3,1),'一二三四五六日')