with r as(
select rank () over (partition by date(log_time) order by log_time asc ) ranking
,date(log_time) log_day
,login_tb.user_id
,hobby
from login_tb
left join user_action_tb
on login_tb.user_id = user_action_tb.user_id
)

select log_day, user_id, hobby
from r
where ranking = 1