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 (5871,5887,5898,5920,8679,8692,8723,10279,10353,10397,10405,10420,10614,14177,14635,14785,16758,16759,16966,17500,18059,19176,19177,19178,21238,21457,21653,21654,21711)
GROUP BY subtyp1 |