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