SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='BIKES' and upper(subtyp1)<>'EMPTY' and style_id IN (1269,11549,14423,15849,16665,17531,17534,17541,17548,17599,17600,17726,17997,18015,18464,18554,18555,18574,18575,18576,18577,18580,18582,18583,18588,20812,20813,21830)
GROUP BY subtyp1 |