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 (429,2156,2915,2977,3260,3407,3549,4854,5225,5298,5551,5653,5744,5882,13959,14282,14283,14489,14683,14684,16148,16670,16672,16676,16802,16846,17170,17199,17348,17806,18774,18947,19264,19266,19282,20054,20221,20376,20878,20879,20880,20976,20978,20980,21249,21255,21261,21371,21372,21373,21374,21375,21382,21570,21573,21577,21579,21634,11356)
GROUP BY subtyp1 |