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 (2093,2094,3843,3848,4004,4005,4097,5056,5058,5062,5074,5075,5140,5149,5150,5170,5209,5329,5476,5477,5616,5617,5669,5678,8411,10000,10053,13988,14589,15575,15794,16649,16651,16652,17269,18169,18214,18718,18777,18780,18791,18948)
GROUP BY subtyp1 |