Johnson Controls Interview Question

Difference between partition by and group by SQL