SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='MENS BIKE CLOTHING' and upper(subtyp1)<>'EMPTY' and style_id IN (2146,2148,2156,2162,5875,5876,5882,5900,8623,10254,10281,10720,10729,14374,14683,14684,15662,15958,16804,18754,19174,19507,21453,21454,21456,21651)
GROUP BY subtyp1 |