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 (4846,4847,4854,4898,14674,14677,14678,17170,17174,17806,17808,18509,18522,19260,19262,19264,19266,19267,19268,19269,19273,19277,19279,19280,19282,20078,20596,20760,21367,21374,21375,21376,21377,21378,21379,21380,21381,21382,21383,21385,21386,21387,21388,11356)
GROUP BY subtyp1 |