What does SELECT 7/2, 7%2, 7.0/2, -7/2 output?

Console output

Why

When both operands are integers, SQLite does integer division that truncates toward zero: 7/2=3 and -7/2=-3. Making one operand real (7.0) switches to floating division (3.5). % is the remainder.