SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CAR RACKS' and typ='ROOF RACKS' and upper(subtyp1)<>'EMPTY' and style_id IN (9956,9964,9965,9974,9976,10012,10041,10042,10043,10044,10046,10062,10070,10078,10079,10087,10090,10093,10115,10117,10120,10121,10122,10139,11154,11162,11163,11164,11165,11166,11169,11170,11181,11201,11202,11204,11206,11207,11208,11209,11210,11211,11214,16798,16850,17120,17382,22522)
GROUP BY subtyp1 |