SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (10760,10788,10841,10856,10874,10877,11589,11592,13911,16013,16015,16017,16019,16021,16022,16215,16216,16219,16221,18227,18228,18234,18236,18239,18378,18380,18381,20522,10875)
GROUP BY subtyp1 |