题解 | 商品id数据清洗统计
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
select product_id, count(1) as cnt
from (
select substring_index(order_id, '_', -1) as product_id
from order_log
) temp
group by product_id
order by product_id
查看7道真题和解析