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,1859,1909,1936,1946,2223,2232,2235,3088,3529,4846,4847,5221,5249,5301,5313,5316,5550,5552,5553,11321,15638,15643,15746,16122,16671,16685,16959,17174,17194,18336,18954,19253,19267,20267,20268,21082,21376,21377,21383,21387,21388,21647)
GROUP BY subtyp1 |