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 (1562,1563,1965,1975,3496,3515,3550,3599,3666,4387,4898,4989,4990,4992,6176,9784,10254,10729,11293,15447,15503,16418,16804,18295,19200,20597,21001)
GROUP BY subtyp1 |