SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='BACKPACKS AND BAGS' and upper(subtyp1)<>'EMPTY' and style_id IN (5072,5106,5107,5115,5168,8378,8379,8380,8381,8390,8431,8432,8433,8437,13885,14270,14271,14566,18794,18906,18907,19306,19346,20096,20933,20934,20950)
GROUP BY subtyp1 |