题解 | 每天登陆最早的用户的内容喜好
WITH temp as (
SELECT
DATE(lt.log_time) as log_day,
MIN(TIME(lt.log_time)) as early_time
FROM
login_tb as lt
GROUP BY
DATE(lt.log_time)
)
SELECT
temp.log_day,
lt.user_id,
ut.hobby
FROM
temp
JOIN
login_tb as lt
ON DATE(lt.log_time) = temp.log_day
AND TIME(lt.log_time) = temp.early_time
LEFT JOIN
user_action_tb as ut
ON lt.user_id = ut.user_id;
投递京东等公司10个岗位