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 (9261,9263,9266,9268,18712,18773,18962,18964,18976,18988,19033,19036,19038,19129,19164,19167,19210,19215,19218,19248,19249,19366,19414,20223,20224,20377,20468,20501,20904,20905,20906)
GROUP BY subtyp1 |