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 (1234,2140,2159,5795,5796,5802,5805,5806,5836,5890,5916,9124,10344,10666,10723,11609,14536,14654,14685,14687,14741,14768,15234,15954,16396,17553,17661,19635,20669,21238,21459,21686,21687)
GROUP BY subtyp1 |