-- 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, 'Aaron', 'M');
INSERT INTO students VALUES (2, 'ARtur', 'M');
-- fetch some values
SELECT * FROM students WHERE gender = 'M';
select * from students where gender = 'F';
select * from students where gender = 'M' or gender ='F';
select * from students ;