题解 | 商品id数据清洗统计
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
select substr(order_id,6,4) product_id,count(*) cnt from order_log group by substr(order_id,6,4) order by cnt limit 1
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
select substr(order_id,6,4) product_id,count(*) cnt from order_log group by substr(order_id,6,4) order by cnt limit 1
相关推荐