题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
select date(log_time) as log_day, u.user_id, hobby
from login_tb as l
left join user_action_tb as u on l.user_id=u.user_id
where log_time in(
select min(log_time)
from login_tb
group by date(log_time))
