SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and subtyp1='Fishing' and upper(subtyp2)<>'EMPTY' and style_id IN (11098,11099,11100,11101,11106,11110,11111,11112,11113,11121,11125,11130,11133,11134,11135,11136,11137,11138,11150,11151,15274,17131,11093,11103,11109,11115,11146)
GROUP BY subtyp2 |