SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAR RACKS' and typ='WATERSPORTS' and upper(subtyp1)<>'EMPTY' and style_id IN (3276,3277,8455,8456,8461,8467,8472,8477,9275,9970,10006,10007,10026,10064,10065,10084,10094,10101,10111,10113,10131,10133,10135,10137,11152,11153,11160,11175,11178,11179,11183,11190,11191,11461,11462,14706)
GROUP BY subtyp1 |