题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select
user_id,
sum(
floor(
timestampdiff(minute, visit_time, leave_time) / 10
)
) as point
from
visit_tb
group by
user_id
order by
point desc;
查看18道真题和解析