SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and subtyp1='Dry Storage' and upper(subtyp2)<>'EMPTY' and style_id IN (1454,1455,1503,1505,1530,1533,1534,1536,1675,1690,4077,4078,5117,5118,5119,5120,8405,8410,8414,8417,8445,8446,8447,8473,8476,14268)
GROUP BY subtyp2 |