SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Accessories' and upper(subtyp2)<>'EMPTY' and style_id IN (10760,10841,10853,10874,11589,11590,11593,13909,13910,16013,16015,16017,16019,16021,16022,16058,16216,16219,16221,18227,18228,18234,18236,18237,18376,18379,18380,18382,20522,20524,20538)
GROUP BY subtyp2 |