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 (472,473,474,3792,3866,4161,4543,4591,4642,9489,13962,13963,13967,15220,15795,16038,16040,17253,17255,18084,18086,18087,19026,19029,19030,19779,19785,21092,21093,475,4088)
GROUP BY subtyp2 |