SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='WOMENS BIKE CLOTHING' and upper(subtyp1)<>'EMPTY' and style_id IN (2160,5823,5826,5828,5833,5847,5871,5898,5920,8679,8692,8693,8723,10279,10339,10353,10397,10405,10420,10614,14177,14635,14636,14783,14785,16758,16759,16966,17500,18056,18059,5837)
GROUP BY subtyp1 |