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 (918,930,953,3201,5221,5236,5249,5279,5301,5302,5307,5313,5316,5339,5479,5662,5696,6046,6047,6048,6050,6062,6067,6293,8800,9400,9899,10760,10841,10853,10979,10983,10985,11578,11589,11593,13909,13910,14255,14678,15830,16013,16015,16019,16022,16058,16093,16094,16097,16098,16126,16216,16219,16221,16224,16366,17194,17620,17621,17623,17811,18127,18228,18234,18236,18237,18250,18376,18379,18380,18382,18384,18386,18388,18393,18395,18535,18541,18669,18672,18673,18793,19352,19353,19379,19381,19497,20051,20267,20293,20368,20396,20465,20524,20538,20569,20635,20636,20843,20934,21262,21269,21271,21276,21281,21282,21284,21288,21366,21367,21368,19629)
GROUP BY subtyp2 |