SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='CAMP KITCHEN' and upper(subtyp1)<>'EMPTY' and style_id IN (1444,1492,1508,1552,1553,2456,2457,3115,3759,3760,3786,3787,3856,3903,4000,4033,4069,4075,4100,14970,15336,17317,17318,19019,19189,21742)
GROUP BY subtyp1 |