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 (5062,5074,5075,5140,5149,5150,5170,5176,5209,11360,17268,17269,18780,18791,18792,19912,19913,19914,19915,19916,19917,19918,20161,21596,21744,21745,21746,21748)
GROUP BY subtyp1 |