SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='BIKES' and subtyp1='Road Bikes' and upper(subtyp2)<>'EMPTY' and style_id IN (1269,10675,11549,15501,17124,17214,17531,17548,17599,17726,17997,18115,18181,18300,18338,18363,18464,18512,18555,18579,18580,18588,18611,18725,18726,18727,18938)
GROUP BY subtyp2 |