题解 | 每天登陆最早的用户的内容喜好
with temp as (
select
user_id,
date(log_time) as log_day,
RANK() OVER(PARTITION BY DATE(log_time) ORDER BY log_time ASC) AS rk
from login_tb )
select
log_day,
a.user_id,
b.hobby
from
temp a join user_action_tb b
on a.user_id=b.user_id and rk=1
投递字节跳动等公司9个岗位
