题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
select log_day, t1. user_id, hobby
from (
select dense_rank() over (partition by date (log_time) order by timestamp(log_time)) as k1 ,user_id,date (log_time) as log_day
from login_tb
) as t1 join user_action_tb on t1.user_id=user_action_tb.user_id
where k1=1
order by log_day
