display FinalResult column 2 times with different name and

Question

Hi team,

 

 i have one table  with field .

 

empcode varchar(100),

FinalResult varchar(100),

date datetime

 

i want result like

 

 

 display FinalResult column 2 times with different name and different where condition in single select statement

 

 I used below query  it gives  present count right but wrong absent day count

 

select empcode,count(finalresult),(select count(finalresult) from elcm_mahsqa.tna.rostering where date between '2016-06-01' and '2016-06-15' and finalresult='a' ) as 'fg' from elcm_mahsqa.tna.rostering where date between '2016-06-01' and '2016-06-15' and finalresult='p' group by empcode.

 

 

please suggest any solution.