https://dbfiddle.uk/9zyERqwV ``` SELECT 1.5 > '1'; SELECT 1.5 > '1.2'; SELECT 1.5 > ('1' + 0); SELECT 1.5 > ('1.2' + 0); SELECT typeof('1' + 0); SELECT typeof('1.2' + 0); ``` https://dba.stackexchange.com/questions/311555/sqlite-spec-4-2-type-conversions-prior-to-comparison https://dba.stackexchange.com/questions/332585/sqlite-comparison-of-the-same-operand-types-behaves-differently https://sqlite.org/forum/info/0f96b67cf2c39ed4