题解 | 商品id数据清洗统计
商品id数据清洗统计
https://www.nowcoder.com/practice/c985ecbd820b46e6bafa858f6600126d
with
t1 as(
select
substring_index(order_id,'_',-1) as product_id
from
order_log
)
,
t2 as(
select
product_id,
count(product_id) as cnt
from
t1
group by
product_id
order by
product_id
)
select * from t2
