SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (5859,7024,10467,10472,10724,11609,14741,15202,16080,16180,16291,17061,17341,17395,17512,17661,17733,17804,19939,20387,20406,20657,20669,21238,21687,21716,21718,21719,21959)
GROUP BY subtyp1 |