How important is business knowledge for SQL querying?

I have been enjoying the interactive code challenge courses on LinkedIn Learning. I just ran into a point of contention of sorts with the solution for a challenge on the SQL Practice: Window Function course. Here’s the problem: Given the entity rela...