SQLite allows you to use a string as a number. It uses whatever prefix of the string that looks like a number. In your case, that prefix is '1'. So the answer of 2.0 is correct.
SQLite allows you to use a string as a number. It uses whatever prefix of the string that looks like a number. In your case, that prefix is '1'. So the answer of 2.0 is correct.