Pregunta de entrevista de Johnson Controls

Difference between partition by and group by SQL