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 (5851,5864,5865,5866,5868,5874,5875,5876,5882,5884,5900,11557,15933,15958,16804,17074,18257,19232,19233,19314,19315,19317,20362,20363,21453,21454,21456)
GROUP BY subtyp1 |