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 (3676,4960,8154,8183,8327,15517,16724,16727,16861,16939,16958,16998,17002,17650,18615,19042,19994,20002,20005,20027,20602,20912,20972,20993,21395,21396,21714)
GROUP BY subtyp1 |