CREATE DATABASE IF NOT EXISTS dm_uam CHARACTER SET utf8 COLLATE utf8_general_ci;

USE dm_uam;

CREATE TABLE clasificacion_alumnos( 
curp VARCHAR(20) PRIMARY KEY,
puntaje_examen INT,
buen_alumno VARCHAR(3)
) 
ENGINE=InnoDB;

INSERT INTO clasificacion_alumnos VALUES ('CURPPR01M1',150,'SI'),('CURPPR01M10',150,'SI'),('CURPPR01M100',160,'NO'),('CURPPR01M11',130,'NO'),('CURPPR01M12',130,'SI'),('CURPPR01M13',145,'SI'),('CURPPR01M14',170,'NO'),('CURPPR01M15',160,'SI'),('CURPPR01M16',140,'SI'),('CURPPR01M17',140,'NO'),('CURPPR01M18',120,'SI'),('CURPPR01M19',140,'NO'),('CURPPR01M2',140,'SI'),('CURPPR01M20',160,'SI'),('CURPPR01M21',130,'SI'),('CURPPR01M22',145,'NO'),('CURPPR01M23',140,'SI'),('CURPPR01M24',130,'NO'),('CURPPR01M25',110,'NO'),('CURPPR01M26',130,'SI'),('CURPPR01M27',145,'SI'),('CURPPR01M28',110,'SI'),('CURPPR01M29',120,'NO'),('CURPPR01M3',150,'NO'),('CURPPR01M30',150,'SI'),('CURPPR01M31',160,'NO'),('CURPPR01M32',145,'SI'),('CURPPR01M33',135,'NO'),('CURPPR01M34',110,'SI'),('CURPPR01M35',125,'SI'),('CURPPR01M36',150,'SI'),('CURPPR01M37',178,'SI'),('CURPPR01M38',160,'NO'),('CURPPR01M39',120,'NO'),('CURPPR01M4',130,'SI'),('CURPPR01M40',130,'NO'),('CURPPR01M41',150,'SI'),('CURPPR01M42',140,'SI'),('CURPPR01M43',120,'NO'),('CURPPR01M44',130,'SI'),('CURPPR01M45',176,'SI'),('CURPPR01M46',140,'SI'),('CURPPR01M47',120,'NO'),('CURPPR01M48',140,'SI'),('CURPPR01M49',145,'NO'),('CURPPR01M5',120,'NO'),('CURPPR01M50',140,'SI'),('CURPPR01M51',130,'NO'),('CURPPR01M52',143,'SI'),('CURPPR01M53',130,'NO'),('CURPPR01M54',160,'SI'),('CURPPR01M55',170,'SI'),('CURPPR01M56',150,'SI'),('CURPPR01M57',140,'NO'),('CURPPR01M58',145,'SI'),('CURPPR01M59',150,'SI'),('CURPPR01M6',100,'SI'),('CURPPR01M60',140,'NO'),('CURPPR01M61',160,'SI'),('CURPPR01M62',160,'SI'),('CURPPR01M63',180,'SI'),('CURPPR01M64',130,'NO'),('CURPPR01M65',160,'SI'),('CURPPR01M66',165,'SI'),('CURPPR01M67',140,'NO'),('CURPPR01M68',160,'SI'),('CURPPR01M69',140,'NO'),('CURPPR01M7',100,'NO'),('CURPPR01M70',145,'SI'),('CURPPR01M71',170,'SI'),('CURPPR01M72',160,'NO'),('CURPPR01M73',160,'SI'),('CURPPR01M74',170,'SI'),('CURPPR01M75',165,'NO'),('CURPPR01M76',170,'SI'),('CURPPR01M77',165,'NO'),('CURPPR01M78',178,'SI'),('CURPPR01M79',170,'SI'),('CURPPR01M8',120,'NO'),('CURPPR01M80',180,'NO'),('CURPPR01M81',180,'NO'),('CURPPR01M82',170,'SI'),('CURPPR01M83',140,'SI'),('CURPPR01M84',145,'NO'),('CURPPR01M85',160,'SI'),('CURPPR01M86',150,'SI'),('CURPPR01M87',148,'SI'),('CURPPR01M88',140,'NO'),('CURPPR01M89',145,'SI'),('CURPPR01M9',150,'SI'),('CURPPR01M90',130,'NO'),('CURPPR01M91',130,'SI'),('CURPPR01M92',150,'SI'),('CURPPR01M93',148,'NO'),('CURPPR01M94',140,'SI'),('CURPPR01M95',150,'SI'),('CURPPR01M96',150,'SI'),('CURPPR01M97',147,'NO'),('CURPPR01M98',160,'SI'),('CURPPR01M99',145,'SI'),('CURPPR02M1',120,'NO'),('CURPPR02M10',110,'SI'),('CURPPR02M100',170,'SI'),('CURPPR02M11',140,'NO'),('CURPPR02M12',150,'SI'),('CURPPR02M13',160,'NO'),('CURPPR02M14',120,'SI'),('CURPPR02M15',140,'SI'),('CURPPR02M16',150,'SI'),('CURPPR02M17',156,'NO'),('CURPPR02M18',160,'NO'),('CURPPR02M19',150,'SI'),('CURPPR02M2',130,'SI'),('CURPPR02M20',140,'SI'),('CURPPR02M21',170,'SI'),('CURPPR02M22',160,'SI'),('CURPPR02M23',150,'SI'),('CURPPR02M24',140,'NO'),('CURPPR02M25',145,'NO'),('CURPPR02M26',168,'SI'),('CURPPR02M27',179,'SI'),('CURPPR02M28',170,'SI'),('CURPPR02M29',120,'NO'),('CURPPR02M3',160,'SI'),('CURPPR02M30',160,'SI'),('CURPPR02M31',140,'SI'),('CURPPR02M32',160,'SI'),('CURPPR02M33',160,'SI'),('CURPPR02M34',130,'NO'),('CURPPR02M35',150,'SI'),('CURPPR02M36',160,'SI'),('CURPPR02M37',150,'SI'),('CURPPR02M38',140,'NO'),('CURPPR02M39',160,'NO'),('CURPPR02M4',180,'SI'),('CURPPR02M40',130,'SI'),('CURPPR02M41',150,'NO'),('CURPPR02M42',160,'SI'),('CURPPR02M43',170,'SI'),('CURPPR02M44',150,'SI'),('CURPPR02M45',160,'SI'),('CURPPR02M46',150,'NO'),('CURPPR02M47',170,'SI'),('CURPPR02M48',140,'SI'),('CURPPR02M49',160,'NO'),('CURPPR02M5',160,'NO'),('CURPPR02M50',170,'SI'),('CURPPR02M51',160,'SI'),('CURPPR02M52',180,'SI'),('CURPPR02M53',170,'SI'),('CURPPR02M54',160,'SI'),('CURPPR02M55',150,'SI'),('CURPPR02M56',130,'NO'),('CURPPR02M57',140,'SI'),('CURPPR02M58',150,'SI'),('CURPPR02M59',150,'SI'),('CURPPR02M6',120,'SI'),('CURPPR02M60',120,'NO'),('CURPPR02M61',140,'SI'),('CURPPR02M62',150,'SI'),('CURPPR02M63',140,'SI'),('CURPPR02M64',150,'SI'),('CURPPR02M65',130,'NO'),('CURPPR02M66',160,'SI'),('CURPPR02M67',150,'SI'),('CURPPR02M68',160,'SI'),('CURPPR02M69',170,'SI'),('CURPPR02M7',150,'NO'),('CURPPR02M70',160,'SI'),('CURPPR02M71',160,'SI'),('CURPPR02M72',170,'SI'),('CURPPR02M73',150,'SI'),('CURPPR02M74',150,'NO'),('CURPPR02M75',160,'SI'),('CURPPR02M76',150,'NO'),('CURPPR02M77',140,'SI'),('CURPPR02M78',145,'SI'),('CURPPR02M79',130,'NO'),('CURPPR02M8',160,'SI'),('CURPPR02M80',140,'SI'),('CURPPR02M81',145,'NO'),('CURPPR02M82',150,'SI'),('CURPPR02M83',146,'SI'),('CURPPR02M84',154,'SI'),('CURPPR02M85',160,'NO'),('CURPPR02M86',145,'SI'),('CURPPR02M87',167,'SI'),('CURPPR02M88',140,'NO'),('CURPPR02M89',156,'SI'),('CURPPR02M9',140,'SI'),('CURPPR02M90',157,'SI'),('CURPPR02M91',168,'SI'),('CURPPR02M92',159,'NO'),('CURPPR02M93',140,'SI'),('CURPPR02M94',167,'SI'),('CURPPR02M95',160,'SI'),('CURPPR02M96',170,'SI'),('CURPPR02M97',178,'SI'),('CURPPR02M98',160,'SI'),('CURPPR02M99',150,'NO');
