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

select log_day
,user_id
,hobby
from 
(
select date(log_time) log_day
,login_tb.user_id
,hobby
,dense_rank()over(partition by date(log_time) order by log_time) r 
from login_tb
join user_action_tb
on login_tb.user_id = user_action_tb.user_id
)ran 
where r = 1
order by log_day