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 (1830,1836,1869,1882,1887,1888,1889,1893,1923,1924,1931,1951,14133,14601,14722,14726,15199,15553,15658,18035,18038,18926,18927,18929,19878,19880)
GROUP BY subtyp1 |