with l as(
    select user_id,date(log_time) as log_day,rank()over(partition by date(log_time) order by log_time) as rn
    from login_tb
)
select log_day,l.user_id,hobby
from l join user_action_tb u on l.user_id=u.user_id
where rn=1 order by log_day