List all SQLite databases To prove the database is indeed created, you can look for the todo.db file in the current folder, or simply issue the following command: sqlite> .databases main: ...

Returning the last value based on a condition seems like a difficult problem to solve unless you try one of these easy-to-implement solutions.