PIVOT columns and replace null values with 0, Sql Server

Language: Layout:

create table #Daysoftheweek (department varchar(10),TotalUtilized int,DayoftheWeek varchar(30))
insert into #Daysoftheweek values 
  ('er','0',convert (varchar(30),getdate()-1,120))
,('icu','1',convert (varchar(30),getdate()-1,120))
,('icu','1',convert (varchar(30),getdate()-2,120))
,('cicu','0',convert (varchar(30),getdate()-3,120))

declare @cols nvarchar (max), @selectcols nvarchar(max), @query nvarchar(max);

set @cols = stuff((
  select distinct ', ' + quotename(convert(nvarchar(30),DayoftheWeek,106))
  from #Daysoftheweek
  for xml path (''), type).value('(./text())[1]','nvarchar(max)')
  ,1,2,'');
set @selectcols = (
  select distinct char(10)+'  , ' + quotename(convert(nvarchar(30),DayoftheWeek,106))
    +' = isnull('     + quotename(convert(nvarchar(30),DayoftheWeek,106)) + ',0)'
  from #Daysoftheweek
  for xml path (''), type).value('(./text())[1]','nvarchar(max)')
set @query = '
select 
    Department '+@selectcols +' 
from (select * from #Daysoftheweek) x
pivot (avg(TotalUtilized)for DayoftheWeek in (' + @cols + ')) p';
    
select CodeGenerated = @query;
exec sp_executesql @query;

View schema
Execution time: 0,03 sec, rows selected: 7, rows affected: 4, absolute service time: 0,17 sec