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 (1830,1869,1887,1888,1889,1893,1923,1924,1931,1951,14133,14601,14722,15199,15432,15434,15553,15658,15734,15735,15742,15910,15913,16784,17180,17182,17489,18035,18038,18276,18927,18929,19103,19878,19880,19953,20132)
GROUP BY subtyp2 |