SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (957,1664,1665,1679,1688,1699,1704,1706,3007,4501,4506,4507,4508,4511,4512,4828,4834,8401,8453,8466,9187,9195,9200,9201,9202,9319,9321,9333,11110,11111,14268,15025,17575,17747,19599,21231,21232,21246,1721,8457,9183,9325,9335,11109,11357)
GROUP BY subtyp1 |