-- 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 (id, gender, name)
    VALUES (3, 'F', 'Martha');

INSERT INTO students (id, gender, name)
    values 
    (4,'M', 'Gabriel'),
    (5,'M', 'Alexis'),
    (6,'F', 'Alicia');

UPDATE students SET gender ='m' 
    WHERE GENDER = 'H';

select * from students ;
DELETE FROM students;
insert into students values (1,'Emile','M');

-- TRUNCATE students;

-- DROP TABLE students;

-- fetch some values
SELECT * FROM students;