题解 | 商品id数据清洗统计
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
select regexp_substr(o.order_id,"[^_]+$") as product_id, count(*) from order_log o group by product_id
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
select regexp_substr(o.order_id,"[^_]+$") as product_id, count(*) from order_log o group by product_id
相关推荐