This is the sort of thing I used to love doing and I often gaze at raw data analysis and sometimes wish my career had pivoted towards working with data like this.

But I must admit there was a point where I suddenly lost my love for SQL and it was pretty much when the OVER PARTITION BY syntax appeared.

It never clicks. I always have to look up how it works, I always find it unintuitive. I've never understood why I hate it so much.