SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='TENTS AND HAMMOCKS' and upper(subtyp1)<>'EMPTY' and style_id IN (571,573,574,592,600,601,614,615,1442,1529,2099,2100,2103,2105,2106,2107,2111,2112,2113,2115,2746,3780,3815,4099,4160,4475,4717,4722,4763,4772,9523,9682,14545,14942,15710,16501,16502,16704,16705,16720,17371,17589,18358,19146,19148,19149,19150,19543,19911)
GROUP BY subtyp1 |