SELECT '当前参数 sj=' + '${sj}' AS 调试信息, DATE_FORMAT(日期, '%Y-%m') AS 月份, 机构名称, SUM(销售金额) AS 机构总销售金额, SUM(销售数量) AS 总销售数量, AVG(成本单价) AS 平均成本单价, SUM(销售金额) - SUM(销售数量) * AVG(成本单价) AS 机构毛利额, ROUND((SUM(销售金额) - SUM(销售数量) * AVG(成本单价)) / NULLIF(SUM(销售金额), 0), 4) AS 机构毛利率, ROW_NUMBER() OVER (PARTITION BY DATE_FORMAT(日期, '%Y-%m') ORDER BY SUM(销售金额) DESC) AS 机构月排名, YEAR(日期) AS 年份, MONTH(日期) AS 月份号FROM 批发运营where 是否内部 = 1 ${if(len(sj)!=0,"and DATE_FORMAT(日期, '%Y-%m')='"+sj+"'","")}GROUP BY DATE_FORMAT(日期, '%Y-%m'), 机构名称, YEAR(日期), MONTH(日期)ORDER BY 年份 DESC, 月份号 DESC, 机构总销售金额 DESC;
