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 (12,1753,1946,2223,3529,4846,4847,5221,5249,5299,5309,5313,5316,5550,5552,9069,9400,11321,14101,14678,15635,15638,15643,15746,16125,16959,18954,19253,19267,20262,20902,21376,21377,21383,21593)
GROUP BY subtyp1 |