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 (1093,6659,6665,7058,7201,7889,10325,11418,11429,11481,14262,15463,15960,16269,16369,16467,17159,17301,18065,18067,18432,18998,19360,20242,20333,20709)
GROUP BY subtyp1 |