WITH Continues_date AS (SELECT user_id, sales_date, ROW_NUMBER() OVER(PARTITION BY user_id ORDER BY sales_date) AS RN FROM sales_tb) SELECT user_id, SUM(days_count) AS days_count / 将所有连续要求的次数求和才是总次数 FROM( SELECT DISTINCT user_id, COUNT(*) AS days_count FROM Continues_date GROUP BY user_id, DATE_ADD(...
