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

来源：互联网发布：java多线程设计模式编辑：程序博客网时间：2024/04/28 18:14

<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.PKIDGROUP BY d.Name ,        c.Name

1 0