@ethansmith6
SQL tip for data problem-solvers:
Window functions are your friends.
They allow you to perform calculations across a set of rows that are somehow related to the current row.
Great for comparing, ranking, and aggregating.
A powerful tool in your problem-solving toolkit.