% (modulo)

a % b returns the remainder when a is divied by b

If you use a % 2 you get 0 for even numbers and 1 for odd numbers.

If you use a % 10 you get the last digit of the number a.

27 % 2  ->  1
27 % 10 ->  7

SELECT yr % 10,
       yr, city
  FROM games

• FLOOR function
• MOD function
• CEIL function