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 (3347,3676,4960,7437,8327,10338,14073,14143,15375,16724,16727,16861,16933,16958,17002,17650,18186,18429,18615,19007,19009,19042,19122,19885,19994,20002,20003,20027,20383,20504,21395,21714,21877)
GROUP BY subtyp1 |