SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAMP AND HIKE' and typ='KNIVES, TOOLS AND GEAR' and upper(subtyp1)<>'EMPTY' and style_id IN (718,752,881,886,897,899,901,905,906,2367,2369,2374,2375,2381,2382,2386,2387,2388,2391,2393,2394,2763,3122,3123,3695,3709,3734,3735,3736,3739,3742,3746,3814,3837,3881,3891,4013,4023,4041,4056,4057,4135,5921,5923,5929,5930,5931,13917,13918,13919,14026,14631,14856,15250,15317,15339,15340,15400,15612,15652,15670,15866,15867,15868,15869,15870,15871,15872,15873,15965,16191,16193,16194,16197,16198,16691,16692,16693,17119,17139,17217,17249,17469,17470,17891,18288,18357,18446,18447,19025)
GROUP BY subtyp1 |