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,1830,1888,1893,1952,3260,4964,14133,14728,14729,14730,15433,15555,15556,15736,15742,16782,16783,16959,17182,17489,18027,18035,18140,18189,19253,19878,19952)
GROUP BY subtyp2 |