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