-- create a table
CREATE TABLE Employees (
  emplyeeID INTEGER PRIMARY KEY,
  FirstName TEXT NOT NULL,
  LastName TEXT NOT NULL,
  UserName TEXT NOT NULL,
  Department TEXT NOT NULL,
    gender TEXT NOT NULL
);
-- insert some values
INSERT INTO Employees VALUES (1, 'Mohamed','Rostamkhan','mrostamkhan','SP&E','M');
INSERT INTO Employees VALUES (2, 'Ely','Daliman','edaliman','SP&E','M');
INSERT INTO Employees VALUES (3, 'Edmyra','Plein','eplein','SP&E','F');
INSERT INTO Employees VALUES (4, 'Armand','Lachman','alachman','SP&E','M');
INSERT INTO Employees VALUES (5, 'Dewindrie','Kewal','dkewal','SP&E','F');
-- fetch some values
SELECT * FROM Employees WHERE gender = 'F';