select
     pl.PollID
    ,pl.PollQuestion
    ,pl.PollAnswerAVirtue
    ,pl.PollAnswerBVirtue
    ,sum(aa.AnswerA) as AnswerA
    ,sum(ab.AnswerB) as AnswerB
from PollLog pl (nolock)
    join (select Pollid,count(*) as AnswerA from VoteLog where VoteAnswer='A' group by Pollid) aa
        on pl.PollId=aa.Pollid
    join (select Pollid,count(*) as AnswerB from VoteLog where VoteAnswer='B' group by Pollid) ab
        on pl.PollId=aa.Pollid
where 1=1
    and pl.pollid in (select max(Pollid) from  PollLog)
    and filter='VVASAS'
    and filter in ('A','B')
group by
     pl.PollID
    ,pl.PollQuestion
    ,pl.PollAnswerAVirtue