-- create a table
CREATE TABLE patient (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO patient VALUES (1, 'Ron', 'M');
INSERT INTO patient VALUES (2, 'Sita', 'F');
INSERT INTO patient  VALUES (3, 'JACK', 'M');
-- fetch some values
SELECT * FROM patient WHERE gender = 'M';