SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (1829,1835,1934,1945,1952,1956,1992,2362,3258,4964,8241,8242,8246,8262,8266,8278,8283,9130,9265,10433,10434,10435,11288,14829,15433,15555,15637,15657,15729,15741,16750,16752,16789,16959,17485,17487,18027,18029,18150,18175,18263,18298,19253,19254,19732,19876,20297,21823,21827)
GROUP BY subtyp2 |