Here is what I have so far.

Select person.id as ID_Number,lastname,firstname, count(datediff(day,jobstartdate,jobenddate)) as Absent_Count

from Person

inner join job

on person.id =job.employeeid

where purgeid = 0

group by Id_Number, lastname, firstname

order by ID_Number asc