构造数据
WITH log_tb AS (
SELECT user_id
,TO_DATE(log_time,'yyyy-mm-dd') AS log_time
FROM (
SELECT 1001 AS user_id
,'2022-04-01' AS log_time
UNION ALL
SELECT 1002 AS user_id
,'2022-04-01' AS log_time
UNION ALL
SELECT 1003 AS user_id
,'2022-04-01' AS log_time
UNION ALL
SELECT 1002 AS user_id
,'2022-04-02' AS log_time
UNION ALL
SELECT 1003 AS user_id
,'2022-04-02' AS log_time
UNION ALL
SELECT 1004 AS user_i