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,784,2138,2221,2223,2232,2235,2829,3092,3098,5330,5360,5362,5552,5645,5719,5722,5731,5752,5753,5763,5865,5884,9060,9915,11319,11557,13961,14282,14489,15499,16670,16672,16802,16846,16959,17348,18423,19264,20695,20980,21252,21260,21373,21574,21577,1615)
GROUP BY subtyp1 |