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 (2080,2081,2082,2086,2093,2094,3843,3848,4004,4011,4097,5056,5058,5075,5081,5085,5109,5140,5171,5176,5177,5180,5181,5209,5476,5477,5617,5669,5678,8411,10000,10053,11359,11360,14237,14579,15563,15575,16649,16651,17267,17268)
GROUP BY subtyp1 |