SQLite - No Such thing as default order

Screen Link:

The results of every query we wrote so far have been ordered by the Rank column.

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?

Hi @prateek

Please attach a link to the mission.

(Guidelines for asking a technical questions in our Community)

Perhaps the optimized way to order data for the SQL engine was the Rank column? As in, it decided to order the query results using Rank Column would provide optimized results.