SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (2006,2362,3309,3314,3347,3352,3676,4217,4960,4968,4999,5019,8152,8154,8183,8320,8327,8329,10433,10934,11625,15055,15516,15517,16507,16581,16628,16724,16729,16861,16863,16939,16958,16997,16998,17002,17647,17650,18134,18511,18615,18846,19042,19076,19122,19126,19751,19810,19885,19994,19997,20002,20003,20005,20027,20211,20213,20325,20602,20993,21606,21609,21714)
GROUP BY subtyp2 |