sql query is giving wrong output

SELECT distinct(k.keyword), p.projectname,pa.username,a.currentposition AS oldposition, b.currentposition AS newposition,pa.KeywordStatus as TimeLineStatus,k.targetdate,k.positionExp 
FROM   seo.tbl_keywordposition a
 JOIN   seo.tbl_keywordposition b ON a.keywordid = b.keywordid AND  a.psnupdatedate = '1/22/2015' AND b.psnupdatedate = '1/23/2015'  left join tbl_keywords k on k.keywordid= a.keywordid and a.keywordid = b.keywordid 
 left join tbl_project p  on p.ProjectId=k.ProjId left join tbl_projAssignment pa on pa.ProjId=p.ProjectId and pa.KeywordID=k.keywordid where  p.Projectname='Homeocare' order by pa.username

SELECT 
    USERNAME 
    , SUM(IMPROVED) IMPROVED
    , SUM(DECREASED) DECREASED
     , SUM(NoChange) NoChange
    , SUM(TimeLineCOMPLETED) TimeLineCOMPLETED
      , SUM(TLNotCompleted) TLNotCompleted
FROM 
(SELECT (k.keyword)
    ,p.projectname
    ,pa.username
    ,CASE 
    
        WHEN a.currentposition > b.currentposition
            THEN 1
        ELSE 0
        END IMPROVED
    ,CASE 
        WHEN b.currentposition > a.currentposition
            THEN 1
        ELSE 0
        END DECREASED
           ,CASE 
        WHEN a.currentposition = b.currentposition
            THEN 1
        ELSE 0
        END NoChange
    ,CASE 
        WHEN pa.KeywordStatus = 'Stopped'
            THEN 1
        ELSE 0
        END TimeLineCOMPLETED
         ,CASE 
        WHEN pa.KeywordStatus = 'InProgress'
            THEN 1
        ELSE 0
        END TLNotCompleted
    ,a.currentposition AS oldposition
    ,b.currentposition AS newposition
    ,pa.KeywordStatus AS TimeLineStatus
    ,k.targetdate
    ,k.positionExp
FROM seo.tbl_keywordposition a
JOIN seo.tbl_keywordposition b ON a.keywordid = b.keywordid
    AND a.psnupdatedate = '1/22/2015'
    AND b.psnupdatedate = '1/23/2015'
LEFT JOIN tbl_keywords k ON k.keywordid = a.keywordid
    AND a.keywordid = b.keywordid
LEFT JOIN tbl_project p ON p.ProjectId = k.ProjId
LEFT JOIN tbl_projAssignment pa ON pa.ProjId = p.ProjectId
        AND pa.KeywordID = k.keywordid
    WHERE p.Projectname = 'Homeocare')INNERQUERY 
GROUP by USERNAME