Practica N° 12

create table alumno(
idalumno char(4) primary key,
paterno varchar(20),
materno varchar(20),
nombre varchar(20));

insert into alumno values('001','Rivas','Quintana','Cesar');
insert into alumno values('002','Rivera','Quino','Ana');
insert into alumno values('003','Castro','Roca','Karina');
insert into alumno values('004','Lopez','Hidalgo','Marina');
insert into alumno values('005','Rivera','Cardenas','Pedro');
insert into alumno values('006','Rojas','Lopez','Juan');
insert into alumno values('007','Malca','Lujan','Maria');

create table curso(
idcurso char(4) primary key,
curso varchar(20));

insert into curso values('01','Matematica');
insert into curso values('02','Fisica');
insert into curso values('03','Quimica');
insert into curso values('04','Literatura');
insert into curso values('05','Biologia');
insert into curso values('06','Filosofia');

create table nota(
idcurso char(4),
idalumno varchar(20),
nota numeric,
unidad TinyInt);

insert into nota values('01','001',15,1);insert into nota values('02','001',13,1);
insert into nota values('03','001',14,1);insert into nota values('04','001',16,1);
insert into nota values('05','001',10,1);insert into nota values('01','002',11,1);
insert into nota values('02','002',08,1);insert into nota values('03','002',12,1);
insert into nota values('04','002',09,1);insert into nota values('05','002',17,1);
insert into nota values('01','003',11,1);insert into nota values('02','003',18,1);
insert into nota values('03','003',17,1);insert into nota values('04','003',14,1);
insert into nota values('05','003',12,1);insert into nota values('01','004',14,1);
insert into nota values('02','004',15,1);insert into nota values('03','004',19,1);
insert into nota values('04','004',12,1);insert into nota values('05','004',14,1);
insert into nota values('01','005',09,1);insert into nota values('02','005',19,1);
insert into nota values('03','005',12,1);insert into nota values('04','005',13,1);
insert into nota values('05','005',14,1);insert into nota values('01','006',09,1);
insert into nota values('02','006',08,1);insert into nota values('03','006',12,1);
insert into nota values('04','006',16,1);insert into nota values('05','006',15,1);
insert into nota values('01','001',11,2);insert into nota values('02','001',12,2);
insert into nota values('03','001',14,2);insert into nota values('04','001',15,2);
insert into nota values('05','001',16,2);insert into nota values('01','002',12,2);
insert into nota values('02','002',18,2);insert into nota values('03','002',13,2);
insert into nota values('04','002',19,2);insert into nota values('05','002',12,2);
insert into nota values('01','003',14,2);insert into nota values('02','003',15,2);
insert into nota values('03','003',16,2);insert into nota values('04','003',17,2);
insert into nota values('05','003',13,2);insert into nota values('01','004',14,2);
insert into nota values('02','004',16,2);insert into nota values('03','004',14,2);
insert into nota values('04','004',16,2);insert into nota values('05','004',17,2);
insert into nota values('01','005',19,2);insert into nota values('02','005',13,2);
insert into nota values('03','005',14,2);insert into nota values('04','005',17,2);
insert into nota values('05','005',09,2);insert into nota values('01','006',07,2);
insert into nota values('02','006',06,2);insert into nota values('03','006',13,2);
insert into nota values('04','006',14,2);insert into nota values('05','006',16,2);
-- Listado de las notas maximas por curso.-- Indicar a quien pertence dichas notas maximas-- Listado del promedio maximo por curso-- Indicar a quienes pertenecen los promedio maximos -- Listado de alumnos indicando su nota por curso: los cursos va como nombre de columna