题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id, sum(diff*1) as point
from (
select user_id,
floor(timestampdiff(minute, visit_time, leave_time)/10) as diff
from visit_tb
) temp
group by user_id
order by point desc
字节跳动开奖364人在聊