月度产品销售数据#

SELECT 
    stat_shop_id AS 门店编号, 
    channel_name AS 订单渠道,
    item_name AS 商品名称, 
    SUM(dp_item_count) AS 产品销量, 
    SUM(dp_pay_amount) AS 产品实收,
    SUM(dp_total_amount) AS 产品流水 
FROM 
    ads_dbs_trade_food_di 
WHERE 
    business_date like '202605%'
GROUP BY 
    stat_shop_id,channel_name,item_name
HAVING 
    SUM(dp_item_count) > 0;