NORMALLY it works:
select count(*) from SALES
partition (SALES_JAN2000)