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

select
    a.log_day,
    a.user_id,
    b.hobby
from
    (select
        user_id,
        date_format(log_time,'%Y-%m-%d') as log_day,
        rank() over(partition by date_format(log_time,'%Y-%m-%d') order by log_time) as r_nm
    from
        login_tb
    ) a
left join
    user_action_tb b on a.user_id = b.user_id
where 
    a.r_nm = '1'
order by 
    1