Filtering (WHERE)
Selecting rows based on conditions with WHERE, comparisons, AND/OR, and LIKE.
Simple enough for a 5-year-old to understand
Filter with WHERE
CREATE TABLE k(name TEXT, age INTEGER);INSERT INTO k VALUES ('Alex', 36), ('Sam', 20);SELECT name FROM k WHERE age >= 30;