check the column name and table name at the below query
select Att_Date ,Att_ScheduledShift ,'absent'=case when att_status ='absent' then count(att_status)else 0 end ,'present'=case when att_status ='present' then count(att_status) else 0 end from Attendance group by Att_ScheduledShift ,Att_Date ,att_status
better you use att_status as integer 0 and 1