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,2006,2362,3309,3314,3347,3690,4217,4388,4960,4968,4999,5019,8152,8183,8202,8327,8329,10338,14073,14143,14571,15055,15090,15375,15516,15881,16507,16581,16724,16729,16861,16866,16958,16997,17002,17609,17611,17860,18133,18134,18417,18511,18846,19042,19068,19076,19231,19384,19475,19613,19751,19885,19994,19997,20002,20003,20027,20211,20213,20383,20912,20972,20993,21395,21396,21606,21609,21714)
GROUP BY subtyp1 |