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