题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
SELECT
user_id,
SUM(FLOOR(TIMESTAMPDIFF(SECOND,visit_time,leave_time) / 60 / 10)) AS 'point'
FROM visit_tb AS a
GROUP BY user_id
ORDER BY point DESC;
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
SELECT
user_id,
SUM(FLOOR(TIMESTAMPDIFF(SECOND,visit_time,leave_time) / 60 / 10)) AS 'point'
FROM visit_tb AS a
GROUP BY user_id
ORDER BY point DESC;
相关推荐