SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (788,793,804,3686,4918,4936,4956,4962,5438,5731,5874,8151,8318,9849,14072,15496,15512,16728,17820,17971,18539,19860,19861,20188,20603,21251,21254)
GROUP BY subtyp1 |