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 (1668,1673,1678,11098,11099,11100,11101,11106,11110,11111,11112,11113,11118,11121,11125,11126,11127,11128,11129,11130,11132,11133,11134,11135,11136,11137,11138,14802,15274,17103,17104,1705,1721,11092,11093,11103,11109,11115,11146)
GROUP BY subtyp2 |