SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='SNOWSPORTS' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (779,2254,2303,2422,2427,2433,7923,7924,9087,9120,9121,9404,9405,9406,9410,9433,9440,9446,9447,9450,9454,9466,9467,9468,9469,9470,9471,9475,9476,9482,10015,11468,13926,14222,15887,15888,16010,16091,16249,9360,9439,9441,9445,9448,9472,9477,9488,11011)
GROUP BY subtyp1 |