This is an interesting SQL parsing quirk! If you have to understand it with an example, it will look like this.

"Count how many students are wearing blue shirt in 8th class" . So here, you plainly stated to look in "8th class" (FROM clause) and "count students wearing blue shirt..." (but did not specify which class to look in!) You did not even inform the class (FROM clause).

When SQLite receives a query without a FROM clause (i.e., without specifying which class to look in), it assumes an empty room. When you count pupils wearing blue shirts in an empty room, the result will always be zero!

You were getting 0 answers because you were counting in an empty space and did not specify which table (or "class") to look in. LibSQL is more stringent and requires you to specify where to check for 'Column0'.