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

# 每天登陆最早的用户（时间重叠重复输出）的喜好
with
t1 as(
    select
        date_format(log_time,'%Y-%m-%d') as log_day,
        user_id,
        hobby,
        rank()over(partition by date_format(log_time,'%Y%m%d') order by log_time) as lrank

    from
        login_tb left join user_action_tb using(user_id)
)
,t2 as(
    select
        log_day,
        user_id,
        hobby
    from
        t1
    where
        lrank=1
    order by
        log_day,
        user_id
)

select * from t2