I made the table and inserted sample data in SSMS and ran this query. After execution I got your desired output :
select Red month, man, sal from
(select DATENAME(month,dob) as Red,count(TypeOfPost) man
from tablename
where TypeOfPost='Manager'
group by DATENAME(month,dob) ) a
full join
(select DATENAME(month,dob) as Green,count(TypeOfPost) sal
from tablename
where TypeOfPost='Sales'
group by DATENAME(month,dob) ) b on B.Green = A.Red
output was :
month man sal
------------------------------ ----------- -----------
January 1 1
June 1 NULL
November 1 1
I think the result is the one you wanted :-?
Is it ok ?