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 (8790,8800,8905,8952,8960,8961,8962,9023,9041,9062,14244,15431,15432,15433,15434,15729,15734,15735,15736,15741,15742,15750,15752,15910,15913,15945,16782,16783,16784,16789,16794,16795,17180,17182,17811,18140,18145,18147,18150,18250,18276,18773,18813,19160,19161,19164,19167,19168,19948,19949,19952,19953,20293,20294,20297,20635,20636,20981,20982)
GROUP BY subtyp1 |