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 (3497,3529,3549,3556,3560,3622,3627,3635,3650,14488,14492,14612,16828,16829,16831,16835,17944,19031,19032,19033,19035,19036,19038,19039,19295,19297,20713,20914,21314,21315,21316,21317,21318,21319)
GROUP BY subtyp1 |