SELECT `option`, SUM(quantity) AS total_quantity FROM `테이블명` WHERE `옵션컬럼` LIKE '%포함제품명%' GROUP BY `옵션컬럼` ORDER BY total_quantity DESC LIMIT 10;
[MySQL] 원하는 브랜드의 옵션 상품별 전체 판매수량 상위 10위 나열하기
SELECT `option`, SUM(quantity) AS total_quantity FROM `테이블명` WHERE `옵션컬럼` LIKE '%포함제품명%' GROUP BY `옵션컬럼` ORDER BY total_quantity DESC LIMIT 10;
2023.08.07