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 (2817,6526,6587,7667,7732,7734,7817,7827,10967,11482,11583,11618,15064,15351,16118,16460,17736,17777,19480,19569,19663,19670,19869,20389,20678,21737,21738,7377)
GROUP BY subtyp1 |