SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='CAMP KITCHEN' and subtyp1='Food' and upper(subtyp2)<>'EMPTY' and style_id IN (2448,2450,2454,2455,3748,3758,3759,3760,3787,3856,3903,4000,4069,4072,4074,4075,4081,15335,15336,15337,15546,15550,17830,18259,19189,19679)
GROUP BY subtyp2 |