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 (5361,5363,5365,5383,5391,5414,5461,5551,5565,5649,5673,14069,14275,15475,15856,16658,16683,16684,17840,17857,19332,19334,20316,21085,21086,21090,21091)
GROUP BY subtyp1 |