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 (553,571,573,574,592,600,601,615,1442,1476,1478,1529,2099,2100,2103,2105,2106,2107,2111,2112,2113,2115,2746,3780,3815,4099,4160,4475,4717,4722,4772,9523,9538,9682,9683,9881,14545,14942,16501,16502,16703,16704,16705,16720,17371,17589,18358,18904,19146,19148,19149,19150,19543,19911,21756,21778)
GROUP BY subtyp1 |