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 (18709,18712,18773,18956,18962,18964,18976,18985,18988,19032,19033,19036,19038,19129,19164,19167,19210,19215,19218,19248,19249,19253,19254,19366,19414,19555,20223,20224,20377,20468,20500,20501,20579,20904,20905,20906)
GROUP BY subtyp1 |