SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='CAMP FURNITURE' and upper(subtyp1)<>'EMPTY' and style_id IN (2099,2100,2103,2104,2105,2106,2107,2109,2111,2112,2113,2115,2743,2751,2753,2755,3817,14171,14432,14435,14436,14437,14542,14546,15615,16709,17186,17187,17188,17189,17191,17192,18089,19499,19500)
GROUP BY subtyp1 |