Question · SQL and MySQL course · Module 3: Filtering (WHERE)

BETWEEN vs comparison operators

Which condition gives the same result as: WHERE cena BETWEEN 20 AND 80 ?

Answer options

  • WHERE cena > 20 AND cena < 80
  • WHERE cena >= 20 AND cena <= 80
  • WHERE cena = 20 OR cena = 80
  • WHERE cena IN (20, 80)

You can check the correct answer by solving this task in the CodeWorlds game.