-- create a table
CREATE TABLE alumnos (
id alumnos INTEGER PRIMARY KEY,
Nombre_alumnos TEXT NOT NULL,
semestre INTEGER NOT NULL,
promedio integer not null,
    promedio_general integer not null
);
-- insert some values
INSERT INTO alumnos VALUES  (1,'Acevedo Mora Francisco Gael','5',8.5,7 );
INSERT INTO students VALUES (2,'Aragon Angelo Karim','5',9.2,7 );
INSERT INTO students VALUES (3,'Ascencio Alvarez Karen Elizabeth','5',8.6,7 );
INSERT INTO students VALUES (4,'Avila Santana Yeslin Brizely','5',8.8,7 );
INSERT INTO students VALUES (5,'Calderon Ceja Ariana Denis','5',7.4,7 );
INSERT INTO students VALUES (6,'Carrazco Flores Axel Miguel','5',6.2,7 );
INSERT INTO students VALUES (7,'Coroy Rodriguez Giovanni Rafael','5',7.4,7 );
INSERT INTO students VALUES (8,'Cruz Murillo Mariana','5',8.3,7 );
INSERT INTO students VALUES (9,'De alba Torres Perla Denisse','5',9.1,7 );
INSERT INTO students VALUES (10,'Delgado Leon Diana Camila','5',9.4,7 );
INSERT INTO students VALUES (11,'Esoinosa Saucedo Milena','5',9.4,7 );
INSERT INTO students VALUES (12,'Flores Sanchez Allizon Yaitzel','5',9.8,7 );
INSERT INTO students VALUES (13,'Gallegos Aviña Perla Jacqueline','5',9,7 );
INSERT INTO students VALUES (14,'Garcia Castro Valeria Guadalupe','5',8.1,7 );
INSERT INTO students VALUES (15,'Garcia Rodriguez Gabdiel','5',8.2,7 );
INSERT INTO students VALUES (16,'Gonzalez Rivera Juan Pablo','5',9.3,7 );
INSERT INTO students VALUES (17,'Gutierrez Duelas Christian Josmar','5',9.8,7 );
INSERT INTO students VALUES (18,'Guititerrez Lopez Litzy Sunare','5',9,7 );
INSERT INTO students VALUES (19,'Hernandez Obispo Yania Alejandra','5',8.8,7 );
INSERT INTO students VALUES (20,'Hernandez Alfaro Fabiola Joleth','5',8.2,7 );
INSERT INTO students VALUES (21,'Hernandez Valencia Romina','5',9.8,7 );
INSERT INTO students VALUES (22,'Jimenez Burgueño Orlando Manuel','5',9.2,7 );
INSERT INTO students VALUES (23,'Juarez Garcia Samadhi Monserrath','5',8.8,7 );
INSERT INTO students VALUES (24,'Juarez Vazquez Josmar Levi','5',9.1,7 );
INSERT INTO students VALUES (25,'Leal Moralez Juan Carlos','5',8.2,7 );
INSERT INTO students VALUES (26,'Marin Rodriguez Balam','5',9.7,7 );
INSERT INTO students VALUES (27,'Martinez Huitzacua william Alexander','5',8.5,7 );
INSERT INTO students VALUES (28,'Medina Sagaste Paulina Guadalupe','5',8.3,7 );
INSERT INTO students VALUES (29,'Martinez Huitzacua william Alexander','5',8.5,7 );
INSERT INTO students VALUES (30,'Martinez Huitzacua william Alexander','5',8.5,7 );





-- fetch some values
SELECT * FROM students WHERE gender = 'F';