Windows function VS Group by Both window functions and GROUP BY help you summarize data. But they do it in different ways, and mixing them up leads to confusing results. GROUP BY squishes many rows into one row per group.
Source: [Dev.to](https://dev.to/mysticg/sql-for-beginners-window-functions-vs-group-by-1pc2)