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 (570,571,573,574,592,594,600,601,614,615,1442,1478,1529,2099,2100,2103,2105,2106,2107,2108,2111,2112,2113,2114,2115,2116,2746,3779,3780,3815,4099,4160,4475,4717,4722,4763,4772,9523,9538,9682,9683,11350,14543,14545,14593,14942,15710,16501,16502,16703,16704,16705,16720,17371,17589,18358,18410,18904,18993,19146,19147,19148,19149,19150,19151,19543)
GROUP BY subtyp1 |