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 (795,798,799,803,804,4957,4968,5732,5762,8152,8320,8723,10614,14067,15055,15516,16143,16729,17751,17752,18185,18427,18537,19858,20506,20508,20820,21239)
GROUP BY subtyp1 |