The results of every query we wrote so far have been ordered by the
Why is that? As far as I know, databases are free to choose whatever column they want to optimize the query and there is no such thing as default order.
However, I can verify that those rows are indeed ordered by rank column (I’ve tried it running SQLite db locally).
What’s going on here?