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 (10263,10344,10382,10386,10387,10391,10407,10467,10468,10472,10484,10503,10504,10506,10509,10511,10512,10514,10589,10590,10593,10627,10634,10666,10698,11512,11609,14741,15034,15371,15954,16080,16460,17388,17733,17804,18755,19204,20669,20926)
GROUP BY subtyp1 |