-- create a table
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (111, 'Ryan', 'M');
INSERT INTO students VALUES (222, 'Joanna', 'F');
INSERT INTO students VALUES (333, 'Joanna', 'F');
-- fetch some values
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;
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');