SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='KAYAKS' and upper(subtyp1)<>'EMPTY' and style_id IN (1670,1671,1681,1682,1683,1684,1695,3012,3020,4713,9160,9163,9167,9176,14854,15018,15020,15021,15022,15023,15024,15779,16371,16372,16687,16688,17097,17735,9177)
GROUP BY subtyp1 |