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

With first_user AS (
    select t1.log_id, t1.user_id, t1.log_time, t2.hobby, t2.score,rank() OVER (
               PARTITION BY DATE(log_time)
               ORDER BY log_time ASC
           ) AS rn
    from login_tb t1
    left join user_action_tb t2
    ON t1.user_id = t2.user_id

)
select date(log_time)AS log_day, user_id, hobby
from first_user
WHERE rn = 1;