SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (419,439,826,1556,1560,1956,1992,2006,2441,2444,3309,3352,3556,3560,3622,3627,3676,3690,4388,4960,4991,4998,5005,5026,6131,6132,6133,6502,7437,8003,8005,8152,8246,8320,9783,10254,11625,13949,14073,14492,14648,14785,14828,14829,15454,15502,15881,16399,16500,16597,16628,16727,16729,16748,16805,16829,16861,16866,16958,17519,17520,17609,18185,18186,18314,18417,18427,18429,18538,18822,18846,19009,19042,19076,19334,19613,19994,19997,20202,20203,20204,20213,20507,20566,20597,20961,21002,21242,21318,21390,21823,21824,21827,21873,21875,21876,21878,21883)
GROUP BY subtyp1 |