-- create a table contador_3c3
CREATE TABLE students (
  id INTEGER PRIMARY KEY,  
  name TEXT NOT NULL,
  apellido_paterno NOT NULL,
  apellido_materno NOT NULL, 
  edad NOT NULL,  
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'Escutia', 'Perez', '20', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'Boca Negra', 'Jimenez', '21', 'F');
INSERT INTO students VALUES (3, 'Jessica', 'Hernández', 'Fuentes', '19', 'F');
INSERT INTO students VALUES (4, 'Nataly', 'Diaz', 'Daza', '19', 'F');
INSERT INTO students VALUES (5, 'Daniel', 'Quijano', 'Rosales', '20', 'M');
INSERT INTO students VALUES (6, 'Jimena', 'Quijano', 'Rosales', '20', 'M');
INSERT INTO students VALUES (7, 'Yoko', 'Quijano', 'Rosales', '20', 'M');

-- fetch some values
SELECT * FROM students