...At my first glance, big number of conditions and the need to aggregate on different criteria at once to return single result value, drawing thoughts to implement the algorithm in procedural way on the API side, using bunch of if-then-else's. However, as I mentioned at the beginning, development approach on this project required somewhat else, so to solve this task I mentally left territory of imperative programming and switched to the side of declarative SQL

...In various videos people ask DeepSeek to write a game in Python, give a piece of advice for children's party or count 'r' in the word 'strawberry'. That is cool, but a little bit off side of my everyday's needs. I am a coder, so I need assistance in coding. That's why I went simple – I took some piece of SQL and asked DeepSeek to explain what is happening there.