Off topic: does any other here have trouble with queries like this?
Rank the employees according to their salaries in each department
My SQL is “good” I think, but to be honest in my day to day I usually don’t deal with aggregation nor windowed queries (my BI colleagues are masters are those, though )