sql 商品在省市及年龄段的分布

<pre name="code" class="sql">SELECT  d.Name [商品] ,
        c.Name [省份] ,
        SUM(a.Numer) [总计] ,
        SUM(CASE WHEN DATEDIFF(year, b.Birthday, GETDATE()) BETWEEN 0 AND 18 THEN Numer ELSE 0 END) '0-18岁', 
        SUM(CASE WHEN DATEDIFF(year, b.Birthday, GETDATE()) BETWEEN 18 AND 38 THEN Numer ELSE 0 END) '18-38岁', 
        SUM(CASE WHEN DATEDIFF(year, b.Birthday, GETDATE()) BETWEEN 38 AND 50 THEN Numer ELSE 0 END) '38-50岁',
        SUM(CASE WHEN DATEDIFF(year, b.Birthday, GETDATE()) BETWEEN 50 AND 200 THEN Numer ELSE 0 END) '50岁以上'
FROM    dbo.ISS_Main_OrderInfo a
        LEFT JOIN dbo.ISS_Base_Customer b ON a.ISS_Base_Customer_PKID = b.PKID
        LEFT JOIN dbo.ISS_System_Province c ON b.ISS_System_Province = c.PKID
        LEFT JOIN dbo.ISS_Base_Commodity d ON a.ISS_Base_Commodity_PKID = d.PKID
GROUP BY d.Name ,
        c.Name