Sql查询，以填充0作为缺失数据

To populate a stacked and grouped highchart I need to add some 0 values into my data. I've tried with a numbers table but could not figure out how to add 0's for every empoloyee missing per date. So I have:To populate a stacked and grouped highchart I n