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 (1751,1754,1758,2156,2225,2226,2915,2977,3001,3529,3549,4846,4847,4854,5221,5249,5298,5301,5361,5391,5551,5638,5755,6139,6316,9023,9041,9150,9927,9931,11278,11312,11402,11404,14244,14635,15760,16401,16803,16870,16959,17194,17199,17857,19253,19352,19972,20059,20267,21059,21314,21317,21355,21361)
GROUP BY subtyp1 |