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 (642,745,779,2254,2271,2276,2301,2302,2303,2422,2427,2433,2434,7923,7924,9076,9087,9088,9095,9120,9121,9123,9345,9363,9404,9405,9406,9410,9429,9440,9446,9447,9450,9451,9453,9454,9466,9468,9469,9470,9471,9481,9482,10014,10015,10016,10019,11467,11468,11471,13926,14222,15886,15887,15888,15889,16010,16011,16033,16091,16249,18204,18205,18206,18207,18209,18273,18275,18433,18473,18503,20485,20486,20607,20608,20609,20621,20740,20741,9360,9439,9441,9445,9448,9472,9477,9488,11011)
GROUP BY subtyp1 |