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

select
    log_day,
    user_id,
    hobby
from (
    select
        date(l.log_time) as log_day,
        dense_rank() over(partition by date(l.log_time) order by l.log_time) as rn,
        l.user_id,
        u.hobby
    from
        login_tb l
    join 
        user_action_tb u on l.user_id = u.user_id
) sys
where
    rn = 1
order by 
    log_day asc