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 (1829,1830,1835,1869,1887,1888,1889,1893,1923,1924,1931,1934,1945,1951,1952,14133,14601,14722,14728,14729,14730,14755,15198,15199,15553,15555,15556,15637,15657,15658,18027,18029,18035,18038,18175,18263,18298,18927,18929,19011,19876,19878,19880)
GROUP BY subtyp1 |