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 (8183,8202,8203,14073,16581,16583,16994,16997,16998,17002,19040,19042,19994,19997,20002,20003,20005,20993,21572,21576,21578,21581,21582,21585,21590,21592,21594,21595,21714,21786)
GROUP BY subtyp1 |