MySQL: octubre 2007

viernes, 19 de octubre de 2007

Practica Nº8

create table Distrito(
idDistrito char(2) primary key,
distrito varchar(20));

insert into distrito values('01','Lima');
insert into distrito values('02','Ancon');
insert into distrito values('03','Ate');
insert into distrito values('04','Barranco');
insert into distrito values('05','Breña');
insert into distrito values('06','Carabayllo');
insert into distrito values('07','Comas');
insert into distrito values('08','Chaclacayo');
insert into distrito values('09','Chorrillo');
insert into distrito values('10','El Agustino');

create table sexo(
idSexo char(1) primary key,
Sexo varchar(20));

insert into sexo values('M','Masculino');
insert into sexo values('F','Femenino');

create table Alumno(
idAlumno char(5) primary key,
paterno varchar(20),
materno varchar(20),
nombre varchar(20),
idDistrito char(2) references Distrito,
idSexo Char(1) references sexo);

insert into Alumno values('00001','Soto','Quispe','Luis Agusto','02','M');
insert into Alumno values('00002','Buleje','Cuba','Cesar','03','M');
insert into Alumno values('00003','Quino','Rios','Cesar Luis','08','M');
insert into Alumno values('00004','Perez','Menacho','Luis Alberto','08','M');
insert into Alumno values('00005','Mallma','Quintana','Karina','03','F');
insert into Alumno values('00006','Villafuerte','Supo','Juan','01','M');
insert into Alumno values('00007','Guzman','Arroyo','Jose Luis','03','M');
insert into Alumno values('00008','Rivas','Lujan','Carlos','06','M');
insert into Alumno values('00009','Castro','Lima','Maria','08','F');
insert into Alumno values('00010','Sotelo','Baca','Ana','08','F');
insert into Alumno values('00011','Soto','Lopez','Adrian','05','M');
insert into Alumno values('00012','Supo','Castro','Karen','07','F');
insert into Alumno values('00013','Garcia','Carrillo','Juan','05','M');

create table Inicio(
idInicio char(5) primary key,
ciclo char(2),
semestre char(7),
fec_inicio datetime);

insert into Inicio values('00001','01','2003-01','20030305');
insert into Inicio values('00002','02','2003-02','20030805');
insert into Inicio values('00003','03','2004-01','20040305');
insert into Inicio values('00004','04','2004-02','20040805');
insert into Inicio values('00005','05','2005-01','20050305');
insert into Inicio values('00006','06','2005-02','20050805');
insert into Inicio values('00007','07','2006-01','20060305');
insert into Inicio values('00008','08','2006-02','20060805');

create table matricula(
idmatricula char(6) primary key,
idAlumno char(5) references alumno,
idInicio char(5) references Inicio,
fecha datetime);

insert into matricula values('030001','00001','00001','20030112');
insert into matricula values('030002','00002','00001','20030112');
insert into matricula values('030003','00003','00001','20030112');
insert into matricula values('030004','00004','00001','20030113');
insert into matricula values('030005','00005','00001','20030113');
insert into matricula values('030006','00006','00001','20030114');
insert into matricula values('030007','00007','00001','20030115');
insert into matricula values('030008','00008','00001','20030116');
insert into matricula values('030009','00009','00001','20030118');
insert into matricula values('030010','00010','00001','20030122');
insert into matricula values('030011','00001','00002','20030713');
insert into matricula values('030012','00002','00002','20030713');
insert into matricula values('030013','00003','00002','20030714');
insert into matricula values('030014','00004','00002','20030814');
insert into matricula values('030015','00005','00002','20030814');
insert into matricula values('030016','00006','00002','20030815');
insert into matricula values('030017','00007','00002','20030816');
insert into matricula values('030018','00008','00002','20030817');
insert into matricula values('030019','00009','00002','20030918');
insert into matricula values('030020','00010','00002','20030924');
insert into matricula values('030021','00001','00003','20040213');
insert into matricula values('030022','00002','00003','20040213');
insert into matricula values('030023','00003','00003','20040214');
insert into matricula values('030024','00004','00003','20040214');
insert into matricula values('030026','00006','00003','20040215');
insert into matricula values('030027','00007','00003','20040216');
insert into matricula values('030028','00008','00003','20040217');
insert into matricula values('030029','00009','00003','20040308');
insert into matricula values('030030','00010','00003','20040309');
insert into matricula values('030031','00001','00004','20040613');
insert into matricula values('030032','00002','00004','20040613');
insert into matricula values('030033','00003','00004','20040614');
insert into matricula values('030034','00004','00004','20040714');
insert into matricula values('030035','00005','00004','20040714');
insert into matricula values('030036','00006','00004','20040715');
insert into matricula values('030037','00007','00004','20040811');
insert into matricula values('030038','00008','00004','20040813');
insert into matricula values('030039','00009','00004','20040805');
insert into matricula values('030040','00010','00004','20040817');
insert into matricula values('030041','00001','00005','20050211');
insert into matricula values('030042','00002','00005','20050211');
insert into matricula values('030043','00003','00005','20050211');
insert into matricula values('030044','00004','00005','20050212');
insert into matricula values('030045','00005','00005','20050213');
insert into matricula values('030046','00006','00005','20050213');
insert into matricula values('030047','00007','00005','20050214');
insert into matricula values('030048','00008','00005','20050214');
insert into matricula values('030049','00009','00005','20050314');
insert into matricula values('030050','00010','00005','20050315');
insert into matricula values('030051','00001','00006','20050711');
insert into matricula values('030052','00002','00006','20050711');
insert into matricula values('030055','00005','00006','20050803');
insert into matricula values('030056','00006','00006','20050813');
insert into matricula values('030057','00007','00006','20050814');
insert into matricula values('030058','00008','00006','20050814');
insert into matricula values('030059','00009','00006','20050814');
insert into matricula values('030060','00010','00006','20050815');
insert into matricula values('030061','00001','00007','20060212');
insert into matricula values('030062','00002','00007','20060212');
insert into matricula values('030063','00003','00007','20060213');
insert into matricula values('030064','00004','00007','20060213');
insert into matricula values('030065','00005','00007','20060213');
insert into matricula values('030066','00006','00007','20060214');
insert into matricula values('030067','00007','00007','20060215');
insert into matricula values('030068','00008','00007','20060216');
insert into matricula values('030069','00009','00007','20060316');
insert into matricula values('030070','00010','00007','20060316');
insert into matricula values('030071','00001','00008','20060612');
insert into matricula values('030072','00002','00008','20060612');
insert into matricula values('030073','00003','00008','20060613');
insert into matricula values('030074','00004','00008','20060713');
insert into matricula values('030075','00005','00008','20060713');
insert into matricula values('030076','00006','00008','20060714');
insert into matricula values('030077','00007','00008','20060715');
insert into matricula values('030079','00009','00008','20060813');
insert into matricula values('030080','00010','00008','20060815');

create table curso(
idcurso char(5) primary key,
curso varchar(30));

insert into curso values('MA100','MATEMÁTICAS-ALGORITMOS');
insert into curso values('DG100','DISEÑO GRÁFICO');
insert into curso values('OF100','DIGITACION');
insert into curso values('MA101','ESTRUCTURA DE DATOS');
insert into curso values('PG101','PROGRAMACION I');
insert into curso values('BD100','BASE DE DATOS I');
insert into curso values('BD101','BASE DE DATOS II');

create table nota(
idmatricula char(9) references matricula,
idcurso char(5) references curso,
periodo char(1),
nota numeric);

insert into nota values('030001','MA100','1',20);
insert into nota values('030002','MA100','1',16);
insert into nota values('030001','MA100','2',17);
insert into nota values('030002','MA100','2',16);
insert into nota values('030001','MA100','3',18);
insert into nota values('030002','MA100','3',15);
insert into nota values('030001','DG100','1',16);
insert into nota values('030002','DG100','1',18);
insert into nota values('030001','DG100','2',15);
insert into nota values('030002','DG100','2',16);
insert into nota values('030001','MA101','1',08);
insert into nota values('030002','MA101','1',06);
insert into nota values('030001','MA101','2',16);
insert into nota values('030002','MA101','2',12);
insert into nota values('030001','MA101','3',13);
insert into nota values('030002','MA101','3',14);
insert into nota values('030001','PG101','1',09);
insert into nota values('030002','PG101','1',10);
insert into nota values('030001','PG101','2',11);
insert into nota values('030002','PG101','2',13);
insert into nota values('030003','MA100','1',12);
insert into nota values('030004','MA100','1',12);
insert into nota values('030003','MA100','2',13);
insert into nota values('030004','MA100','2',14);
insert into nota values('030003','MA100','3',08);
insert into nota values('030004','MA100','3',05);
insert into nota values('030003','DG100','1',12);
insert into nota values('030004','DG100','1',11);
insert into nota values('030003','DG100','2',14);
insert into nota values('030004','DG100','2',14);
insert into nota values('030003','MA101','1',18);
insert into nota values('030004','MA101','1',09);
insert into nota values('030003','MA101','2',12);
insert into nota values('030004','MA101','2',11);
insert into nota values('030003','MA101','3',13);
insert into nota values('030004','MA101','3',15);
insert into nota values('030003','PG101','1',19);
insert into nota values('030004','PG101','1',20);
insert into nota values('030003','PG101','2',13);
insert into nota values('030004','PG101','2',14);

--obs. Considera los datos de los alumnos paterno, materno y nombres
--1.- Listado de alumnas mujeres que viven en 'Chaclacayo'
--2.- Cantidad de alumnos por sexo
--3.- Cantidad de alumnos por distrito
--4.- Cantidad de alumnos matriculados por sexo
--5.- Cantidad de alumnos matriculados por distrito
--6.- Listado de alumnos que al menos uno de sus nombres sea 'Luis'
--7.- Listado de alumnos matriculados en el semestre 2005-01
--8.- Cantidad de alumnos matriculados por semestre
--9.- Cantidad de alumnos desaprobados por ciclo y semestre
--10.-Listado de alumnos con promedio de notas por curso
--11.-Alumnos que nunca se han matriculado
--12.-Alumnos que no tienen ninguna nota
--13.-En que distritos no hay alumnos
--14.-En que Inicio no hay alumnos
--15.-Alumnas mujeres que no tienen nota en ningun curso
--16.-En que cursos no hay nota
--17.-Listado de alumnos que viven en Breña y nunca se han matriculado
--18.-Alumnos que se han matriculado el 12 de enero del 2003
--19.-Alumnos que no se han matriculado en el semestre '2005-02'
--20.-Alumnas mujeres que se han matriculado en el semestre
-- '2005-02', '2005-01' y '2004-02'

viernes, 12 de octubre de 2007

Referencia Cruzada

Create table notas(
idMatricula Char(3) primary key,
idCurso char(5),
nota numeric,
unidad
);
insert into notas values('001','MA100',10,1);
insert into notas values('001','MA100',14,2);
insert into notas values('001','MA100',11,3);
insert into notas values('002','MA100',08,4);
insert into notas values('002','MA100',15,3);
insert into notas values('002','MA100',6,4);
insert into notas values('002','MA100',10,4);
insert into notas values('003','MA100',19,4);
insert into notas values('003','MA100',20,5);
insert into notas values('001','FI100',11,1);
insert into notas values('001','FI100',15,2);
insert into notas values('001','FI100',16,3);
insert into notas values('002','FI100',09,4);
insert into notas values('002','FI100',14,3);
insert into notas values('002','FI100',9,4);
insert into notas values('002','FI100',08,4);
insert into notas values('003','FI100',16,4);
insert into notas values('003','FI100',13,5);
insert into notas values('001','QI100',10,1);
insert into notas values('001','QI100',11,2);
insert into notas values('001','QI100',12,3);
insert into notas values('002','QI100',14,4);
insert into notas values('002','QI100',08,3);
insert into notas values('002','QI100',12,4);
insert into notas values('002','QI100',18,4);
insert into notas values('003','QI100',17,4);
insert into notas values('003','QI100',04,5);

-- Cantidad de alumnos por Curso. Donde El nombre de curso sea la columna

Practica Nº7

miércoles, 3 de octubre de 2007

Examen Final Nº2

Correr el script y realizar las siguiente consultas

Listado de alumnos que viven en ‘ATE’ y cuyo apellido inicia con la letra A
Listado de alumnos desaprobados. Indicar los nombres de los alumnos y su nota correspondiente
Listado de alumnos cuyo apellido paterno, materno o nombre exista la letra ‘S’
Cantidad de alumnos por distrito
Cantidad de alumnos por sexo
Promedio de notas de cada alumno por ciclo
Listado de alumnos indicando los cursos que lleva y su nota correspondiente del semestre 2005-01
Cantidad de alumnos por distrito, sexo y curso
Número de alumnos cuyo promedio de notas esta entre 11 y 16
Puntaje total por alumno (puntaje =suma de todas sus notas)

Inicio Script
________________________________________

create table Distrito(
idDistrito char(2) primary key,
distrito varchar(20)
);

insert into distrito values('01','Lima');
insert into distrito values('02','Ancon');
insert into distrito values('03','Ate');
insert into distrito values('04','Barranco');
insert into distrito values('05','Breña');
insert into distrito values('06','Carabayllo');
insert into distrito values('07','Comas');
insert into distrito values('08','Chaclacayo');
insert into distrito values('09','Chorrillo');
insert into distrito values('10','El Agustino');

create table alumno(
idalumno char(4) primary key,
paterno varchar(30),
materno varchar(30),
nombre varchar(30),
sexo char(2),
fec_nac date,
idDistrito char(2)
);

insert into alumno values('0001','RIVERA','SOTO','CARLOS','M','19890512','02');
insert into alumno values('0002','ARIAS','SOTO','LUIS','M','19870515','03');
insert into alumno values('0003','CARDENAS','SOTO','MARTA','F','19841216','04');
insert into alumno values('0004','LOPEZ','SOTO','AUGUSTO','M','19900819','02');
insert into alumno values('0005','CASTRO','GARCIA','JOSE','M','19880613','06');
insert into alumno values('0006','GARCIA','QUINO','ROBERTO','M','19890113','02');
insert into alumno values('0007','SOTO','QUISPE','CESAR','M','19910913','03');
insert into alumno values('0008','SOTELO','CARRILLO','MARIA','F','19890505','02');
insert into alumno values('0009','RIVERA','TOLEDO','ANA','F','19830608','04');
insert into alumno values('0010','RIVERA','CARPIO','KARINA','M','19810613','06');

create table matricula(
idmatricula char(5),
idalumno char(4) references alumno,
semestre char(7),
fecha date
);
insert into matricula values('05001','0001','2004-01','20040101');
insert into matricula values('05002','0002','2004-01','20040201');
insert into matricula values('05003','0003','2004-01','20040302');
insert into matricula values('05004','0004','2004-01','20040303');
insert into matricula values('05005','0005','2004-01','20040401');
insert into matricula values('05006','0006','2004-01','20040404');
insert into matricula values('05007','0007','2004-01','20040405');
insert into matricula values('05008','0008','2004-01','20040302');
insert into matricula values('05009','0009','2004-01','20040403');
insert into matricula values('05010','0010','2004-01','20040101');

insert into matricula values('05011','0001','2004-02','20040801');
insert into matricula values('05012','0002','2004-02','20040801');
insert into matricula values('05013','0003','2004-02','20040702');
insert into matricula values('05014','0004','2004-02','20040806');
insert into matricula values('05015','0005','2004-02','20040805');
insert into matricula values('05016','0006','2004-02','20040703');
insert into matricula values('05017','0007','2004-02','20040704');
insert into matricula values('05018','0008','2004-02','20040802');
insert into matricula values('05019','0009','2004-02','20040806');
insert into matricula values('05020','0010','2004-02','20040701');

insert into matricula values('05021','0001','2005-01','20050802');
insert into matricula values('05022','0002','2005-01','20050804');
insert into matricula values('05023','0003','2005-01','20050706');
insert into matricula values('05024','0004','2005-01','20050807');
insert into matricula values('05025','0005','2005-01','20050809');
insert into matricula values('05026','0006','2005-01','20050713');
insert into matricula values('05027','0007','2005-01','20050714');
insert into matricula values('05028','0008','2005-01','20050812');
insert into matricula values('05029','0009','2005-01','20050816');
insert into matricula values('05030','0010','2005-01','20050711');

insert into matricula values('05031','0001','2005-02','20050802');
insert into matricula values('05032','0002','2005-02','20050804');
insert into matricula values('05033','0003','2005-02','20050706');
insert into matricula values('05034','0004','2005-02','20050807');
insert into matricula values('05035','0005','2005-02','20050809');
insert into matricula values('05036','0006','2005-02','20050713');
insert into matricula values('05037','0007','2005-02','20050714');
insert into matricula values('05038','0008','2005-02','20050812');
insert into matricula values('05039','0009','2005-02','20050816');
insert into matricula values('05040','0010','2005-02','20050711');

insert into matricula values('05041','0001','2006-01','20060102');
insert into matricula values('05042','0002','2006-01','20060205');
insert into matricula values('05043','0003','2006-01','20060306');
insert into matricula values('05044','0004','2006-01','20060206');
insert into matricula values('05045','0005','2006-01','20060203');
insert into matricula values('05046','0006','2006-01','20060314');
insert into matricula values('05047','0007','2006-01','20060215');
insert into matricula values('05048','0008','2006-01','20060216');
insert into matricula values('05049','0009','2006-01','20060316');
insert into matricula values('05050','0010','2006-01','20060412');

insert into matricula values('05051','0001','2006-02','20060801');
insert into matricula values('05052','0002','2006-02','20060705');
insert into matricula values('05053','0003','2006-02','20060806');
insert into matricula values('05054','0004','2006-02','20060705');
insert into matricula values('05055','0005','2006-02','20060704');
insert into matricula values('05056','0006','2006-02','20060815');
insert into matricula values('05057','0007','2006-02','20060816');
insert into matricula values('05058','0008','2006-02','20060815');
insert into matricula values('05059','0009','2006-02','20060714');
insert into matricula values('05060','0010','2006-02','20060813');

insert into matricula values('05061','0001','2007-02','20070801');
insert into matricula values('05062','0002','2007-02','20070705');
insert into matricula values('05063','0003','2007-02','20070806');
insert into matricula values('05064','0004','2007-02','20070705');
insert into matricula values('05065','0005','2007-02','20070704');
insert into matricula values('05066','0006','2007-02','20070815');
insert into matricula values('05067','0007','2007-02','20070816');
insert into matricula values('05068','0008','2007-02','20070815');
insert into matricula values('05069','0009','2007-02','20070714');
insert into matricula values('05070','0010','2007-02','20070813');

create table curso(
idcurso char(2) primary key,
curso varchar(30)
);

insert into curso values('01','MATEMATICA');
insert into curso values('02','FISICA');
insert into curso values('03','QUIMEICA');
insert into curso values('04','BIOLOGIA');
insert into curso values('05','PSICOLOGIA');
insert into curso values('06','FILOSOFIA');
insert into curso values('07','HISTORIA DEL PERU');
insert into curso values('08','LITERATURA');
insert into curso values('09','HISTORIA UNIVERSAL');
insert into curso values('10','LENGUAJE');

create table nota(
idmatricula char(5),
idcurso char(2),
nota numeric,
unidad char(1)
);

insert into nota values('05021','01',12,'1');
insert into nota values('05021','02',13,'1');
insert into nota values('05021','03',08,'1');
insert into nota values('05021','01',12,'2');
insert into nota values('05021','02',13,'2');
insert into nota values('05021','03',08,'2');

insert into nota values('05022','01',11,'1');
insert into nota values('05022','02',10,'1');
insert into nota values('05022','03',08,'1');
insert into nota values('05022','01',15,'2');
insert into nota values('05022','02',11,'2');
insert into nota values('05022','03',14,'2');

insert into nota values('05023','01',19,'1');
insert into nota values('05023','02',10,'1');
insert into nota values('05023','03',11,'1');
insert into nota values('05023','01',16,'2');
insert into nota values('05023','02',12,'2');
insert into nota values('05023','03',09,'2');

insert into nota values('05024','01',08,'1');
insert into nota values('05024','02',10,'1');
insert into nota values('05024','03',17,'1');
insert into nota values('05024','01',18,'2');
insert into nota values('05024','02',12,'2');
insert into nota values('05024','03',14,'2');

insert into nota values('05031','04',10,'1');
insert into nota values('05031','05',11,'1');
insert into nota values('05031','06',13,'1');
insert into nota values('05031','04',15,'2');
insert into nota values('05031','05',08,'2');
insert into nota values('05031','06',19,'2');

insert into nota values('05032','04',12,'1');
insert into nota values('05032','05',11,'1');
insert into nota values('05032','06',12,'1');
insert into nota values('05032','04',14,'2');
insert into nota values('05032','05',13,'2');
insert into nota values('05032','06',09,'2');

insert into nota values('05033','04',11,'1');
insert into nota values('05033','05',14,'1');
insert into nota values('05033','06',16,'1');
insert into nota values('05033','04',18,'2');
insert into nota values('05033','05',05,'2');
insert into nota values('05033','06',06,'2');

insert into nota values('05034','04',12,'1');
insert into nota values('05034','05',11,'1');
insert into nota values('05034','06',15,'1');
insert into nota values('05034','04',13,'2');
insert into nota values('05034','05',17,'2');
insert into nota values('05034','06',09,'2');

insert into nota values('05035','04',16,'1');
insert into nota values('05035','05',13,'1');
insert into nota values('05035','06',14,'1');
insert into nota values('05035','04',15,'2');
insert into nota values('05035','05',16,'2');
insert into nota values('05035','06',12,'2');

insert into nota values('05036','04',11,'1');
insert into nota values('05036','05',08,'1');
insert into nota values('05036','06',04,'1');
insert into nota values('05036','04',06,'2');
insert into nota values('05036','05',07,'2');
insert into nota values('05036','06',12,'2');

insert into nota values('05037','04',14,'1');
insert into nota values('05037','05',15,'1');
insert into nota values('05037','06',16,'1');
insert into nota values('05037','04',08,'2');
insert into nota values('05037','05',09,'2');
insert into nota values('05037','06',10,'2');

insert into nota values('05038','04',16,'1');
insert into nota values('05038','05',17,'1');
insert into nota values('05038','06',08,'1');
insert into nota values('05038','04',09,'2');
insert into nota values('05038','05',10,'2');
insert into nota values('05038','06',11,'2');

insert into nota values('05039','04',11,'1');
insert into nota values('05039','05',10,'1');
insert into nota values('05039','06',10,'1');
insert into nota values('05039','04',09,'2');
insert into nota values('05039','05',08,'2');
insert into nota values('05039','06',10,'2');

insert into nota values('05040','04',10,'1');
insert into nota values('05040','05',11,'1');
insert into nota values('05040','06',15,'1');
insert into nota values('05040','04',05,'2');
insert into nota values('05040','05',08,'2');
insert into nota values('05040','06',09,'2');

insert into nota values('05051','07',11,'1');
insert into nota values('05051','08',12,'1');
insert into nota values('05051','09',11,'1');
insert into nota values('05051','07',11,'2');
insert into nota values('05051','08',13,'2');
insert into nota values('05051','09',14,'2');

insert into nota values('05052','07',15,'1');
insert into nota values('05052','08',15,'1');
insert into nota values('05052','09',15,'1');
insert into nota values('05052','07',15,'2');
insert into nota values('05052','08',15,'2');
insert into nota values('05052','09',15,'2');

insert into nota values('05053','07',13,'1');
insert into nota values('05053','08',11,'1');
insert into nota values('05053','09',15,'1');
insert into nota values('05053','07',16,'2');
insert into nota values('05053','08',10,'2');
insert into nota values('05053','09',11,'2');

insert into nota values('05054','07',11,'1');
insert into nota values('05054','08',12,'1');
insert into nota values('05054','09',12,'1');
insert into nota values('05054','07',13,'2');
insert into nota values('05054','08',13,'2');
insert into nota values('05054','09',06,'2');

insert into nota values('05055','07',11,'1');
insert into nota values('05055','08',15,'1');
insert into nota values('05055','09',14,'1');
insert into nota values('05055','07',13,'2');
insert into nota values('05055','08',12,'2');
insert into nota values('05055','09',10,'2');

insert into nota values('05056','07',08,'1');
insert into nota values('05056','08',10,'1');
insert into nota values('05056','09',11,'1');
insert into nota values('05056','07',13,'2');
insert into nota values('05056','08',10,'2');
insert into nota values('05056','09',09,'2');

insert into nota values('05057','07',15,'1');
insert into nota values('05057','08',11,'1');
insert into nota values('05057','09',12,'1');
insert into nota values('05057','07',13,'2');
insert into nota values('05057','08',10,'2');
insert into nota values('05057','09',14,'2');

insert into nota values('05058','07',19,'1');
insert into nota values('05058','07',15,'1');
insert into nota values('05058','07',16,'1');
insert into nota values('05058','07',13,'2');
insert into nota values('05058','07',14,'2');
insert into nota values('05058','07',10,'2');

insert into nota values('05059','07',15,'1');
insert into nota values('05059','08',14,'1');
insert into nota values('05059','09',15,'1');
insert into nota values('05059','07',11,'2');
insert into nota values('05059','08',12,'2');
insert into nota values('05059','09',13,'2');

insert into nota values('05060','07',12,'1');
insert into nota values('05060','08',13,'1');
insert into nota values('05060','09',14,'1');
insert into nota values('05060','07',15,'2');
insert into nota values('05060','08',16,'2');
insert into nota values('05060','09',17,'2');

Fin Script
________________________________________

MySQL

Archivo del blog

Datos personales