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 (420,946,1744,1777,1830,1869,1887,1888,1889,1893,1923,1924,1931,1951,2173,2176,10874,14133,14601,14722,15199,15432,15434,15553,15658,15734,15735,15742,15910,15913,16017,16021,16498,16768,16784,16879,17180,17182,17489,18035,18038,18276,18927,18929,19103,19492,19878,19880,19953,20132,20294)
GROUP BY subtyp1 |