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 (439,442,1383,2441,2442,2444,3556,3627,6133,6502,7437,8003,8327,8639,10286,10338,10631,11309,14492,14782,14806,14842,15251,15517,16399,16400,16805,16829,20150,20597,20713,21231,21232,21242,21318)
GROUP BY subtyp1 |