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 (378,1557,1558,1559,1560,1825,1956,1998,2006,2362,2442,3309,3314,3347,3352,3690,4217,4388,4960,4968,4991,4999,5005,5019,5026,6502,7437,8152,8183,8241,8242,8266,8320,9783,10254,10338,10631,11288,11625,13949,14073,14229,14648,14782,14828,14829,14842,15090,15451,15452,15502,15516,15697,15881,16583,16628,16729,16861,16863,16866,16939,16958,16961,16994,17002,17519,17520,18133,18134,18186,18417,18615,18823,18824,19008,19068,19076,19142,19143,19193,19384,19751,19885,20002,20005,20027,20028,20211,20213,20365,20490,20504,20505,20506,20507,20508,20602,20912,20972,20993,21002,21395,21396,21606,21609,21823,21824,21827,21873,21875,21877,21878,21880,21883)
GROUP BY subtyp1 |