SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (826,2441,3309,3352,3622,3690,5026,6132,6133,11625,14648,14785,16628,16829,17519,17520,17609,18133,18417,18846,19076,19613,20202,20213,21318,21873,21876,21878)
GROUP BY subtyp1 |