Hi,
You need to get before 10 days data then use DATEADD Function like
SELECT ColumnList FROM tableName WHERE your_date_column BETWEEN GETDATE() AND DATEADD(DAY,-10,GETDATE)
SELECT M.b, M.YY, M.MM ,
(SELECT COUNT(b) FROM tableName
WHERE b=M.b
AND CAST(YY AS VARCHAR(4)) + CAST(MM AS VARCHAR(2)) + CAST(DD AS VARCHAR(2))
BETWEEN CONVERT(VARCHAR(10),(DATEADD(DAY,-10,GETDATE())),112) AND CONVERT(VARCHAR(10),GETDATE(),112)
)'Before_10_Days',
(SELECT COUNT(b) FROM tableName
WHERE b=M.b
AND CAST(YY AS VARCHAR(4))+CAST(MM AS VARCHAR(2)) +CAST(DD AS VARCHAR(2))
BETWEEN CONVERT(VARCHAR(10),(DATEADD(DAY,-15,GETDATE())),112) AND CONVERT(VARCHAR(10),GETDATE(),112)
) 'Before_15_Days'
FROM tableName M
GROUP BY M.b, M.YY, M.MM
Regards,
GVPrabu