赠茶数据需求#

WITH day_periods AS (
    SELECT '20260327' AS start_date, '20260504' AS end_date
)
SELECT
    CONCAT(day_periods.start_date, '~', day_periods.end_date) AS 时段,
    business_date AS 日期,
    city_name AS 城市,
    item_name AS 产品名称,
    SUM(dp_item_count) AS 销量,
    SUM(dp_total_amount) AS 流水,
    SUM(dp_pay_amount) AS 实收
FROM
    ads_dbs_trade_food_di
CROSS JOIN day_periods
WHERE
    business_date BETWEEN day_periods.start_date AND day_periods.end_date AND city_name in ('蚌埠市','阜阳市','淮南市')
GROUP BY
    时段,
    日期,
    城市, 
    产品名称
HAVING
    SUM(dp_item_count) > 0
    AND SUM(dp_pay_amount) = 0;