SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CYCLING' and typ='BIKE TOOLS' and upper(subtyp1)<>'EMPTY' and style_id IN (961,1087,2509,6424,6578,6780,6781,6986,7016,7125,7177,7194,7496,7558,7611,7663,7738,7858,10222,10400,10594,14147,15367,15461,15580,17637,17920,18402,18516,18517,18652,18756,18759,19206,19228,19370,19371,19669,19748,19764,19796,19872,19889,19898,19899,959,6362)
GROUP BY subtyp1 |