SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='MORE...' and typ='TRAVEL' and upper(subtyp1)<>'EMPTY' and style_id IN (2094,3843,3848,3931,4004,4005,4006,5062,5074,5075,5140,5170,5209,5476,5477,5617,5678,10000,10053,11360,13988,14589,14597,15575,17268,17269,17766,18780,18791,18792,18948,19912,19913,19914,19915,19917,19918,20137,20161,21596)
GROUP BY subtyp1 |