CREATE TABLE lpu (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);

INSERT INTO lpu VALUES (1, 'Aryan', 'M');
INSERT INTO lpu VALUES (2, 'Akansha', 'F');
INSERT INTO lpu VALUES (3, 'Yash', 'M');
INSERT INTO lpu VALUES (4, 'Divya', 'F');
INSERT INTO lpu VALUES (5, 'Rahul', 'M');
INSERT INTO lpu VALUES (6, 'Suryansh', 'M')

SELECT * FROM lpu WHERE gender = 'F';