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 (3206,3210,3215,3235,3406,3408,5298,6045,6054,10981,10984,10993,15617,15856,15945,16948,17199,17680,18121,18390,18469,19380,19382,19628,20223,20224,20316,20377,20468,20501,20514,21015,21272,21273,21277,21278,21280,21283,21285,21286,21365,6049)
GROUP BY subtyp2 |