SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users (first_name TEXT, surname TEXT, age INTEGER, salary INTEGER);
✓
INSERT INTO users VALUES ('Rolf', 'Smith', 35, 55000);
✓
INSERT INTO users VALUES ('Bob', 'Smith', 37, 45000);
✓
INSERT INTO users VALUES ('Anne', 'Pun', 31, 87000);
✓
INSERT INTO users VALUES ('Charlie', 'Robert', 70, 99000);
✓
SELECT * FROM users WHERE first_name = 'Rolf';


first_name
surname
age
salary


Rolf
Smith
35
55000


SELECT * FROM users WHERE age > 33;


first_name
surname
age
salary


Rolf
Smith
35
55000

Bob
Smith
37
45000

Charlie
Robert
70
99000


SELECT * FROM users WHERE salary > 50000;


first_name
surname
age
salary


Rolf
Smith
35
55000

Anne
Pun
31
87000

Charlie
Robert
70
99000


SELECT * FROM users WHERE salary > 50000 AND age < 35;


first_name
surname
age
salary


Anne
Pun
31
87000


SELECT first_name, surname, age, salary
FROM users
WHERE (age <= 18 OR age >= 65) AND salary > 0;


first_name
surname
age
salary


Charlie
Robert
70
99000