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 (5794,5795,5796,5801,5802,5805,5806,5836,5859,5888,5890,5895,5909,5915,5916,5917,11558,11618,15932,18256,19235,19316,19317,21459,21460,21461)
GROUP BY subtyp1 |