题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
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
