SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='MORE...' and typ='PUBLICATIONS' and subtyp1='Maps' and upper(subtyp2)<>'EMPTY' and style_id IN (200,206,472,473,474,3792,3866,3867,4161,4167,4543,4606,4642,9489,13962,13963,13967,13969,15220,15795,16038,16040,17255,17257,18084,18085,18086,18087,19026,19028,19029,19030,475,4088)
GROUP BY subtyp2 |