SELECT
    log_day,
    user_id,
    hobby
FROM(
SELECT
    l.user_id,
    DATE(log_time) AS log_day,
    DENSE_RANK() OVER(PARTITION BY DATE(log_time) ORDER BY log_time) AS time_rank,
    log_time,
    hobby
FROM login_tb l
JOIN user_action_tb u
ON l.user_id = u.user_id
) AS tb1
WHERE time_rank = 1