SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='BACKPACKS AND BAGS' and subtyp1='Daypacks' and upper(subtyp2)<>'EMPTY' and style_id IN (1759,1760,1761,2019,2035,4486,5046,5065,5067,5068,5077,5078,5145,5163,5165,5166,5196,8378,9511,9690,9777,9946,13986,14246,14250,14267,14272,14273,14400,14401,14574,14575,14815,15222,15223,16646,16648,17106,17107)
GROUP BY subtyp2 |