select 
    style_id,
    count(item_id) as SPU_num
from 
    product_tb
group by 
    1
order by 
    SPU_num desc