CREATE TABLE ALUMNOS (
    no_control VARCHAR(20) PRIMARY KEY,
    nombre VARCHAR(100) NOT NULL,
    carrera VARCHAR(50) DEFAULT 'OFIMATICA',
    grupo VARCHAR(10) DEFAULT '5DM',
    turno VARCHAR(20) DEFAULT 'MATUTINO'
);

INSERT INTO ALUMNOS (no_control, nombre) VALUES
('24302052370271', 'ACEVEDO CARRERA ESTEFANY'),
('24302052370272', 'ACOSTA MANDUJANO MIA NICOLE'),
('24302052370273', 'ACOSTA SOTO KAREN AVRIL'),
('24302052370274', 'ALVAREZ PORTUGUES TABATHA AIDEE'),
('24302052370275', 'ALVAREZ QUEZADA OSCAR ADRIAN'),
('24302052370276', 'ALVAREZ VILLANUEVA MAITE'),
('24302052370543', 'AQUINO CASIANO DANIEL'),
('24302052370277', 'ARAUJO MEDRANO DANIEL'),
('24302052370278', 'ARAUJO MEDRANO MELANY'),
('24302052370279', 'ARCOS PAZOS KEREN ELISA'),
('24302052370280', 'ASTUDILLO VARGAS KEVIN CRISTSER'),
('24302052370281', 'CEDILLO SAIZ CLAUDIA NOEMI'),
('24302052370282', 'CHAVEZ MORALES JACOB'),
('24302052370285', 'ESQUIVEL CHAVEZ MIA ARACELY'),
('24302052370286', 'FERNANDEZ ROMERO TANIA'),
('24302052370287', 'FLORES LOPEZ JAIME HIRAM'),
('24302052370288', 'GALVAN BASTIDAS DIEGO IVAN'),
('24302052370289', 'GARCIA GONZALEZ JUAN GERMAN'),
('24302052370290', 'GOMEZ RUIZ EMILY NOEMI'),
('24302052370291', 'GUERRERO CORTES JOSE MANUEL'),
('24302052370293', 'HABANA MATEOS BRISA LIZBETH'),
('24302052370294', 'HERNANDEZ CASTRO ESTHEFANY VALENTINA'),
('24302052370295', 'HERNANDEZ GONZALEZ CAROLINA'),
('24302052370296', 'HERNANDEZ PLATA DIEGO MYZAEL'),
('24302052370297', 'HERNANDEZ SANTIZ LUIS ALBERTO'),
('24302052370298', 'HERRERA FONSECA YARED DANIEL'),
('24302052370299', 'JIMENEZ CANDELARIO CRISTOPHER'),
('24302052370300', 'JIMENEZ RODRIGUEZ JUAN ENRIQUE'),
('24302052370301', 'LEONARDO CEDILLO BRAYAN'),
('24302052370565', 'LOAIZA RODRIGUEZ CAMILLA ALEXANDRA'),
('24302052370302', 'LOPEZ CALZADA ALMA YAMILET'),
('24302052370303', 'LOPEZ YOC CARLA YARELI'),
('24302052370304', 'MARTINEZ MORENO ARICK DAMIAN'),
('24302052370305', 'MARTINEZ RIVERA RAUL DERECK'),
('24302052370306', 'MAYA MUNGUIA DANIEL'),
('24302052370307', 'MEJIA CANO ANDRES'),
('24302052370308', 'NAVA GOMEZ JOSE SANTIAGO'),
('24302052370309', 'PARRA CANIZALES NESTOR ALAN'),
('24302052370311', 'PEREZ ABRAJAM CARMEN JAMILETH'),
('24302052370312', 'PUGA HERRERA ALLISON NAHOMI'),
('24302052370579', 'RAMIREZ RUIZ PALOMA VALENTINA'),
('24302052370313', 'REYES PIÑON NAHOMI VANESSA'),
('24302052370315', 'ROMAN MUÑOZ DIONISIO'),
('24302052370582', 'ROMERO ORTEGA CITLAHLY'),
('24302052370317', 'RUIZ ROMERO KERELYN VICTORIA'),
('24302052370318', 'SALCEDO CARVAJAL BRYANNA LIZETH'),
('24302052370320', 'SANDOVAL VACA ALEJANDRO'),
('24302052370322', 'VICENTE AYALA HADID SINAI'),
('24302052370323', 'ZAMORA ZARAGOZA FRIDA GUADALUPE'),
('24302052370325', 'ZUÑIGA GONZALEZ EDGAR EDUARDO');

SELECT * FROM ALUMNOS;