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 (1750,1754,1758,2156,2915,2977,3001,3549,4854,5298,5361,5391,5551,8069,11278,11312,11402,11404,14635,16401,16803,17199,17857,19210,19215,19218,19972,21314,21317,21355)
GROUP BY subtyp1 |