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 (8802,8814,8820,8854,8867,8904,8919,9021,9022,9045,9046,9060,9063,9069,14256,15732,15743,15744,15745,15746,15747,15748,15749,15844,15912,15914,15945,16786,16787,17811,18137,18138,18141,18153,18154,18155,18250,18279,18336,18498,18774,19079,19082,19139,19157,19950,19951,19954,20156,20292,20293,20294,20296,20385,20635,20636,20976,20977,20978,20979,20980,20983,8912)
GROUP BY subtyp1 |