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 (6139,6240,6265,6293,6295,6316,11402,11404,14515,16399,16400,16401,16405,16406,16408,16410,17895,17913,18709,18712,18713,18714,18717,19414,19423,19970,19972,20150,20871,20875,20876,21127)
GROUP BY subtyp1 |