SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='MENS BIKE CLOTHING' and subtyp1='Bike Shoes' and upper(subtyp2)<>'EMPTY' and style_id IN (2821,6502,7437,8623,8639,8664,10254,10281,10286,10334,10338,10608,10631,10687,14374,14782,14806,14807,14842,15105,16755,16756,16757,17004,17265,18754)
GROUP BY subtyp2 |