SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='SNOWSPORTS' and typ='ACCESSORIES' and subtyp1='Wax and Tuning Supplies' and upper(subtyp2)<>'EMPTY' and style_id IN (9363,9405,9406,9410,9429,9440,9446,9447,9450,9451,9466,9469,9470,9471,9482,14222,16091,18204,18206,18207,18209,20864,20956,9360,9439,9441,9445,9448,9472,9477,9488,11011)
GROUP BY subtyp2 |