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,2449,2450,2451,2452,2453,2454,2455,2458,2459,3748,3758,3759,3787,3856,3903,3967,3968,4000,4069,4070,4071,4072,4074,4075,4080,4081,13970,15336,15546,15547,15589,15590)
GROUP BY subtyp2 |