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 (1319,1341,1368,1385,1750,1754,1758,2148,2915,2975,2998,3001,3002,3408,3549,4854,5298,5361,5363,5391,5551,5565,5649,5673,5920,6265,6295,8069,11278,11312,11402,11404,14069,14488,14635,14642,14683,15750,15752,16616,16803,16807,16948,17199,17857,19031,19215,19218,20871,20875,20876,20957,20958,20968,21086,21091,21128,21131,21134,21235,21240,21314,21315,21316,21317,21355,21356,21362,21363,21364,21389)
GROUP BY subtyp1 |