题解 | 统计用户获得积分
WITH t1 AS (
SELECT
info_id,
user_id,
FLOOR(timestampdiff(minute,visit_time,leave_time)/10) pts
FROM visit_tb
)
SELECT
user_id,
SUM(pts) point
FROM t1
GROUP BY user_id
ORDER BY point DESC
02-09 17:36 University College London 战略分析 发布于海南
关注
投递华为HUAWEI等公司10个岗位