-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
    age  INTEGER
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M',13);
INSERT INTO students VALUES (2, 'Joanna', 'M',12);
INSERT INTO students VALUES (3, 'viraja', 'M',14);
INSERT INTO students VALUES (4, 'arav', 'M',16);
-- fetch some values
SELECT * FROM students WHERE gender = 'M';