1234567891011
-- create a tableCREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL);-- insert some valuesINSERT INTO students VALUES (1, 'Ryan', 'M');INSERT INTO students VALUES (2, 'Joanna', 'F');-- fetch some valuesSELECT * FROM students WHERE gender = 'F';