select sum(t1.CU_order_amount) as 金额,
t3.CU_name as 地区
from CU_order t1
inner join CU_cust_info t2 on t1.CU_cust_id = t2.CU_cust_id
inner join CU_city t3 on t2.CU_city_id = t3.CU_city_id
where t1.BillDate between '20160101' and '20171231'
group by t3.CU_name
※ 引述《nd5287 (Mike)》之铭言：
: 数据库名称：
: 数据库版本：sql 2014
: 内容/问题描述：
: 我下了 以下的语法查询出的结果如下
: select DISTINCT B.CU_order_amount "金额",D.CU_name as "地区",
: B.BillDate as "日期" from CU_order B
: join CU_cust_info C on B.CU_cust_id=C.CU_cust_id
: join CU_city D on C.CU_city_id = D.CU_Id
: where B.CU_cust_id in
: (select CU_cust_id from CU_cust_info C where CU_city_id in (select CU_city_id
: from CU_city ))
: and B.BillDate Between '20160101' and '20171231'
: order by B.CU_order_amount desc
: 金额 地区 日期
: