SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='COMPONENTS' and upper(subtyp1)<>'EMPTY' and style_id IN (6482,6885,6904,7110,7133,7252,7356,7372,7431,7438,7467,7473,7649,7777,7883,7884,7887,8582,8590,8591,8600,8601,8610,8618,8620,8622,8640,8643,8663,8683,8703,8717,10325,10379,10495,11429,11488,13928,14105,14680,14997,15332,16293,16402,16403,17055,17685,17797,17823,17964,18266,18515,18998,20123,20242,20559,20778)
GROUP BY subtyp1 |