I strongly suggest testing your statements in the sqlite shell first, and listening to what SQLite says about them. You can handle problems with your API calls later, when you have already validated the SQL-
I strongly suggest testing your statements in the sqlite shell first, and listening to what SQLite says about them. You can handle problems with your API calls later, when you have already validated the SQL-