Between sql ORACLE

Hello
-- The following SQL statement is working
select * from hr.employees
where email = 'SKING' or email = 'LDEHAAN';

-- The following SQL statement is not working
select * from hr.employees
where email between 'SKING' and 'LDEHAAN';

Do you help me please I have no idea

when you use BETWEEN, the low value goes first.

try:

select * from hr.employees
where email between 'LDEHAAN' and 'SKING'