What does SELECT 1=1, 1=2, 5 BETWEEN 1 AND 10, NULL=NULL output?

Console output

Why

SQLite represents booleans as integers 1 (true) and 0 (false), so 1=1 prints 1 and 1=2 prints 0. NULL=NULL is NULL, not true — equality with NULL is always unknown. Use IS NULL to test for NULL.