SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (960,6417,6438,7233,7593,7607,7608,7610,7622,7721,7786,7830,8739,10387,10634,10698,11452,14135,15382,15900,15901,16310,19293,20772,20926,2163)
GROUP BY subtyp1 |