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 (1066,1236,1275,1276,6653,10355,10391,10512,10670,15371,16117,16491,17153,17388,17822,19235,19477,19664,19978,20035,20653,20654,20655,20656,20658,21459)
GROUP BY subtyp1 |