The GROUP BY clause reduces the number of rows returned by rolling them up and calculating the sums or averages for each group.
The PARTITION BY clause does not reduce the number of rows returned. - SQL PARTITION BY / Introduction to Window Functions