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 (2810,2821,2823,4256,6502,6558,6863,7256,7437,8623,8639,8664,10254,10281,10286,10332,10334,10338,10608,10631,10687,10699,14374,14782,14784,14806,14807,14842,15105,16755,16756,16757,17004,17265)
GROUP BY subtyp2 |