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 (1383,2441,2442,2444,3560,3627,5383,6502,8003,8005,8639,10608,11309,14492,14612,14782,16399,16400,16805,16829,19142,19143,19334,19591,20597,20961,21232,21242,21390)
GROUP BY subtyp1 |