111541SELECT department_area_code 地区,round(BIll_ssum,-1) 客单价, count(1) 数量 FROM BI_RETAIL r
INNER JOIN BI_DEPOT d
ON r.SET_DEPARTMENT_ID=d.DEPARTMENT_ID
WHERE BIll_ssum>0 AND to_char(BILL_SUM_SUREDATE,'yyyy-mm')=to_char(SYSDATE,'yyyy-mm')
GROUP BY department_area_code,round(BIll_ssum,-1)
--HAVING count(1) >300
ORDER BY department_area_code,数量 DESC