select date(log_time) as log_day,
    user_id,
    hobby
from (
    select user_id,
        dense_rank() over(partition by date(log_time) order by log_time) as ranking,
        log_time,
        hobby
    from login_tb
    left join user_action_tb
        using(user_id)
) t
where ranking = 1