-- 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 (1, 'Ryan','M');
INSERT INTO students VALUES (2, 'Joanna','F');
INSERT INTO students VALUES (3, 'Raul', 'M');
INSERT INTO students VALUES (4, 'Roman','M');
INSERT INTO students VALUES (5, 'Juana', 'F');
INSERT INTO students VALUES (6, 'Rene','M');
INSERT INTO students VALUES (7, 'Julia', 'F');
-- fetch some values
SELECT * FROM students