SQL - LIKE, BETWEEN, IN
Overview
Use LIKE for patterns, BETWEEN for ranges, and IN for membership tests.
SELECT * FROM employees
WHERE first_name LIKE 'A%'
AND salary BETWEEN 50000 AND 150000
AND department_id IN (1,2,3);
SELECT * FROM employees
WHERE first_name LIKE N'A%'
AND salary BETWEEN 50000 AND 150000
AND department_id IN (1,2,3);
SELECT * FROM employees
WHERE first_name LIKE 'A%'
AND salary BETWEEN 50000 AND 150000
AND department_id IN (1,2,3);
Prerequisite
Load the Standard Test Data.
Expected Output
id | first_name | department_id | salary | hired_at
---+------------+---------------+----------+---------------------
1 | Ada | 1 | 120000.00| 2021-01-10 10:00:00