New posts in Partition By

Cannot use group by and over(partition by) in the same query?