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 (950,2225,2226,2233,2234,8790,8952,11590,14728,14729,14730,14755,15198,15431,15556,15736,16157,16782,16783,18140,18145,18147,18227,19011,19069,19948,19949,19952,20522,21842)
GROUP BY subtyp1 |