题解 | 商品id数据清洗统计
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
WITH goods AS (
SELECT
SUBSTRING(order_id, POSITION('_' IN order_id)+1) AS product_id,
uid
FROM order_log
)
SELECT
product_id,
COUNT(uid) AS cnt
FROM goods
GROUP BY product_id
ORDER BY cnt DESC
LIMIT 1
