SQL AND: Examples

Examples
Sample Database

#1

SELECT
	first_name,
	last_name,
	job_id,
	salary
FROM
	employees
WHERE
	job_id = 9
AND salary > 5000;

#2

SELECT
	first_name,
	last_name,
	hire_date
FROM
	employees
WHERE
	CAST(strftime('%Y',hire_date) AS INTEGER) >=1997
AND CAST(strftime('%Y',hire_date) AS INTEGER) <= 1998;

Table List

countries

SELECT * FROM countries;

departments

SELECT * FROM departments;

dependents

SELECT * FROM dependents;

employees

SELECT * FROM employees;

jobs

SELECT * FROM jobs;

locations

SELECT * FROM locations;

regions

SELECT * FROM regions;

SQL Query

Execute

Clear Beautify Minify

Reload

Result