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 (28,31,384,393,394,4835,9186,9189,9190,9191,9192,9193,9196,9197,9318,9329,16694,16697,17033,17034,17035,19615,19627,8363,9323,9330,9339)
GROUP BY subtyp1 |