Hi,
For newentries do you want to print 1 record for each week or only the last week count. I am not clear with your requirement. Why don't you try a query like this.

Select ADVTISE_TYPE, count(*) as Count FROM abc where ADVISE_TYPE IN('WANTED', 'SALES')
group by ADVTISE_TYPE
UNION ALL
Select ADVTISE_TYPE, count(*) as Count FROM abc where ADVISE_TYPE = 'NEWENTRIES' and adddate>(sysdate-7)
group by ADVTISE_TYPE


With regards
V.Sathishkumar