题解 | 每天登陆最早的用户的内容喜好

SELECT a.date log_day,a.user_id,b.hobby
FROM (
    SELECT t1.user_id,t1.date
    FROM (
        SELECT DATE(log_time) date,user_id,DENSE_RANK() OVER(partition by DATE(log_time)order by log_time) date_ranking
        FROM login_tb
    ) t1
    WHERE t1.date_ranking = 1
) a
LEFT JOIN user_action_tb b
ON a.user_id = b.user_id