题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id,sum(if(timestampdiff(minute,visit_time,leave_time)>=10,floor(timestampdiff(minute,visit_time,leave_time)/10),0)) as point from visit_tb group by user_id order by point desc;
OPPO公司福利 1225人发布