SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and subtyp1='PFDs' and upper(subtyp2)<>'EMPTY' and style_id IN (383,384,386,393,394,4494,4496,4500,4503,4506,4507,4508,4509,4511,4512,9186,9187,9190,9191,9192,9193,9196,9197,9200,9201,13897,16694,16695,16696,16697,17033,17034,17035,19627)
GROUP BY subtyp2 |