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 (1659,1670,1681,1682,1683,1684,1695,3006,3012,3020,4711,4713,9160,9161,9162,9163,9170,9176,14854,14855,15018,15020,15021,15022,15023,15024,15779,16371,16372,16687,16688,17097,17735,18902,19598)
GROUP BY subtyp1 |