题解 | 商品id数据清洗统计
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
select
REGEXP_SUBSTR(order_id,'p[0-9]+') as product_id,
count(REGEXP_SUBSTR(order_id,'p[0-9]+')) as cnt
from
order_log
group by
1
order by
cnt desc
limit 1
