try this
with T as (
select
empid,
case when [P/A]='P' then 1 end as 'P',
case when [P/A]='A' then 1 end as 'A',
case when [P/A]='L' then 1 end as 'L'
from attendance where empid = 909 )
select sum(P) as P, sum(A) as A, sum(L) as L,empid from T group by empid