题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
with by_day as (
select user_id,date(log_time) log_day from login_tb where log_time in (
(select min(log_time) time from login_tb group by date(log_time))))
select b.log_day,a.user_id,a.hobby from user_action_tb a join by_day b on a.user_id=b.user_id order by b.log_day
SHEIN希音公司福利 337人发布