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 (1663,1664,1673,1678,1699,1702,3007,11098,11099,11100,11106,11110,11111,11112,11113,11121,11125,11130,11132,11133,11134,11135,11136,11137,11138,11330,17102,17103,17131,17574,19599,1721,11093,11103,11109,11115,11146)
GROUP BY subtyp2 |