Untitled Page

CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    gender TEXT NOT NULL
);

INSERT INTO students VALUES (111, 'Ryan', 'M');
INSERT INTO students VALUES (222, 'Joanna', 'F');
INSERT INTO students VALUES (333, 'Joanna', 'F');

SELECT * FROM students ORDER BY name DESC;

SELECT MAX(ID) FROM students;
SELECT MIN(ID) FROM students;
DELETE FROM students WHERE id > 300;
SELECT * FROM students WHERE name = 'Ryan';
SELECT COUNT(ID) FROM students;

SELECT * FROM students WHERE gender = 'F';
SELECT * FROM students WHERE name LIKE '_a';
SELECT * FROM students WHERE name LIKE '_a%';
SELECT * FROM students WHERE name LIKE 'j%';
SELECT * FROM students WHERE name LIKE '%%';

SELECT * FROM students WHERE id > 200 ORDER BY name ASC;
SELECT * FROM students WHERE id = 111;
SELECT * FROM students WHERE id BETWEEN 100 AND 300;
SELECT * FROM students WHERE id IN (111, 400);
SELECT * FROM students WHERE name IN ('Ryan', 'Joana');