SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and subtyp1='Outfitting' and upper(subtyp2)<>'EMPTY' and style_id IN (1432,1433,1663,1664,1673,1678,1699,1702,1734,11098,11099,11100,11106,11111,11113,11121,11125,11130,11133,11134,11135,11136,11137,11138,17102,17103,17131,17574,19599,22365,1721,11109,11146,19522)
GROUP BY subtyp2 |