SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (3347,3676,4960,8183,8202,8327,14073,14143,15090,16724,16861,16866,16958,17002,17650,19042,19068,19231,19384,19885,19994,20002,20003,20027,20383,20912,20972,20993,21395,21396,21714)
GROUP BY subtyp2 |