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;