-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  address TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M', 'New York');
INSERT INTO students VALUES (2, 'Joanna', 'F', 'Virginia');
INSERT INTO students VALUES (3, 'Jennifer', 'F', 'New Jersey');
INSERT INTO students VALUES (4, 'Daniel', 'M', 'Chicago');
-- fetch all values
SELECT * FROM students;
select * from students where gender = 'M';
select * from students where gender = 'F';
select * from students where gender = 'M' or gender  = 'F';
select * from students ;