What does SELECT '5' + 3, '5abc' + 3, 'abc' + 3, '3.2' + 1 output?

Console output

Why

SQLite's + is arithmetic. Text operands are cast to numbers by parsing a leading numeric prefix; text with no leading number becomes 0. So '5'+3=8, '5abc'+3=8, 'abc'+3=3, and '3.2'+1=4.2. (Use || to concatenate strings.)