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 (3496,3497,3515,3529,3549,3550,3589,3599,3604,3620,3623,3625,3637,3638,3641,3664,3666,3669,14489,14619,14620,16112,16832,16845,16846,17934,17935,18974,18975,20409,20417,20735,20913,21369,21371,21372,21373,21634)
GROUP BY subtyp1 |