SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and upper(subtyp1)<>'EMPTY' and style_id IN (2136,2444,2446,3324,3347,3635,3676,4960,5637,5719,5745,5754,7437,8154,8183,8202,8327,8664,9495,9927,9931,10279,10334,10338,10631,10687,10934,14073,14143,14229,14782,14806,15090,15375,15517,15763,15881,16087,16724,16727,16861,16863,16866,16933,16939,16958,16994,16998,17002,17625,17650,17944,18186,18261,18312,18429,18538,18615,18616,19007,19009,19040,19042,19068,19122,19231,19256,19384,19885,19994,20002,20003,20005,20027,20203,20337,20365,20383,20504,20505,20507,20566,20577,20602,20912,20972,20993,21057,21233,21237,21395,21396,21581,21595,21714,21877)
GROUP BY subtyp1 |