SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Accessories' and upper(subtyp2)<>'EMPTY' and style_id IN (2778,2779,2799,3073,3201,3206,3210,3215,3224,3235,3408,3471,4848,5236,5249,5279,5296,5298,5302,5307,5313,5316,5339,5479,5662,6045,6064,8350,8800,9400,9428,9493,9495,10140,10762,10979,10981,10983,10984,10993,13960,13987,14678,14765,14766,15617,15946,15992,16095,16301,16338,16366,16367,16584,16667,16680,16768,16769,17400,17461,17576,17577,17578,1292,1294,2332,2354,6049)
GROUP BY subtyp2 |