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