SELECT style_id,
       COUNT(style_id) AS SPU_num
       FROM product_tb
GROUP BY style_id
ORDER BY SPU_num DESC;