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

with t as (
    select user_id, log_time
    from (
        select user_id, log_time,
        dense_rank() over (partition by date(log_time) order by log_time) as dr
        from login_tb
    ) temp
    where dr=1
)
select date(log_time) as log_day, t.user_id, hobby
from t join user_action_tb u on t.user_id=u.user_id
order by log_day