题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
select
DATE(log_time) as log_day,
a.user_id,
hobby
from (
select *,
rank() over(partition by date(log_time) order by time(log_time)) as rnk
from login_tb lt
) a left join user_action_tb uat
on a.user_id = uat.user_id
where rnk = 1
ORDER BY log_day ASC
