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,1556,1558,1559,1560,2006,3556,3627,4991,4999,5019,5383,5461,6131,8005,9783,10254,11290,11309,14425,14492,15451,15452,15454,15455,16399,16400,16631,16805,16947,19334,20597,21000,21002,21135,21231,21232,21242,21390,21824,21875,21883)
GROUP BY subtyp1 |