SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='MORE...' and typ='SUNGLASSES AND READERS' and upper(subtyp1)<>'EMPTY' and style_id IN (4938,9110,14926,14932,14933,15162,15168,15169,15390,16231,16285,17508,17658,17660,19430,19433,19434,19435,19692,19693,19694,19697,19698,19699,19700,19702)
GROUP BY subtyp1 |