SELECT
shop_id
FROM (
SELECT
shop_id,
SUM(CASE WHEN order_date = CURRENT_DATE THEN 1 ELSE 0 END) AS today_cnt,
SUM(CASE WHEN order_date >= date_sub(CURRENT_DATE, 7) AND order_date < CURRENT_DATE THEN 1 ELSE 0 END) / 7.0 AS avg_7_cnt
FROM orders
WHERE order_date >= date_sub(CURRENT_DATE, 7) -- 近7天及今天
AND order_date <= CURRENT_DATE
GROUP BY shop_id
) t
WHERE today_cnt >= 2 * avg_7_cnt
;
