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,5833,5871,5886,5898,5920,8679,8692,8693,8723,10279,10353,10397,10405,10420,10614,14177,14635,14636,14785,16758,16759,16901,16966,17500,18056,18662,19085,19162,19163,19176,19177,19178,19234,19237,19238,19502,5837)
GROUP BY subtyp1 |