SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (3354,3669,3689,4973,4993,4995,8639,14619,14620,14648,15105,15448,16112,16511,16725,16832,17612,19057,19073,21078,21244,21248,21256,21871,21872,21879)
GROUP BY subtyp1 |