题解 | 统计用户获得积分-SQL
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
SELECT
user_id,
SUM(diff) AS point
FROM
(
SELECT
user_id,
FLOOR(
TIMESTAMPDIFF(MINUTE, visit_time, leave_time) / 10
) AS diff
FROM
visit_tb
) as t
GROUP BY
user_id
ORDER BY
point DESC
查看12道真题和解析