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

select
        b.log_day,
        b.user_id,
        uatb.hobby
from 
        user_action_tb as uatb
inner join (
    select
        a.user_id,
        date(a.log_time) as log_day
    from (
        select
            *,
            rank() over(partition by date(log_time) order by log_time) as rn
        from 
                login_tb
    )a
    where 
            a.rn = 1
)b
on 
        uatb.user_id = b.user_id
order by
        log_day