题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id,
sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) as point
from visit_tb
where timestampdiff(minute,visit_time,leave_time)>10
group by user_id
order by point desc;
查看5道真题和解析
而且一般说的也很宽泛 不是特指后端