Pregunta de entrevista de Tinder

Coding take-home assessment: one SQL, one python, one open question. SQL and Python. SQL on the harder side (joins, window functions, etc) - SQL one passed 5 out of 7 trial tests. I couldn't understand where the issue was. What frustrated me about this is that if it was a live coding section, it was obvious that I knew how to code on SQL. They use a software that gives a final score (given by share of passes tests and speed as far as I understand), don't know if then someone reviews the code. - Python one was very basic; it was just a groupby. But then they asked for the solution to be ordered in certain way. When I ordered it, it failed the tests, and when looking at the expected outcome vs my outcome...the expected one was not sorted as required, mine was. So I tried eliminating the sort of my code and pass the test cases...I don't know how many more tests it runs for the score. Again, I left a note in my code about this discrepancy and the commented code of how I was sorting it. No idea if someone reviews afterwards.