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 (10675,15125,15956,16433,16434,16436,16494,17214,17547,17608,17698,17703,17765,17966,18023,18024,18075,18362,18365,18610,18611,18612,18727,18730,18731,18732,18734,18735,18938,20031,20839,20840)
GROUP BY subtyp1 |