EXAMEN BDII 03AN

Correr el Script Siguiente en MySQL y desarrollar las siguientes consultas

CREATE DATABASE EXAMEN;
USE EXAMEN;
CREATE TABLE DISTRITO(
idDistrito char(2)
primary key,
distrito varchar(20));

INSERT INTO distrito values('01','Lima');
INSERT INTO distrito values('02','Ate');
INSERT INTO distrito values('03','Comas');
INSERT INTO distrito values('04','Surco');
INSERT INTO distrito values('05','Lince');
INSERT INTO distrito values('06','Jesus Maria');
INSERT INTO distrito values('07','Surquillo');
INSERT INTO distrito values('08','San Isisdro');
INSERT INTO distrito values('09','Los OLivos');
INSERT INTO distrito values('10','San Martin de Porres');
INSERT INTO distrito values('11','Ancon');

CREATE TABLE ALUMNO(
idalumno char(4) primary key,
paterno varchar(20),
materno varchar(20),
nombre varchar(20),
direccion varchar(50),
iddistrito char(2) references distrito,
correo varchar(30),
sexo char(1),
dia char(1));

INSERT INTO ALUMNO VALUES('0001','Soto','Rivas','Carla','Jr Ica 123','04','csoto@hotmail.com','F','2');
INSERT INTO ALUMNO VALUES('0002','Sotelo','Rojas','Jorge','Av Arequipe 230','05','jsotelo@hotmail.com','M','3');
INSERT INTO ALUMNO VALUES('0003','Rivera','Rivas','Jose','Jr Faisanes 223','01','jrivera@gmail.com','M','4');
INSERT INTO ALUMNO VALUES('0004','Carrillo','Castro','Katy','Jr Bolivia 123','02','kcarrillo@yaho.com','F','5');
INSERT INTO ALUMNO VALUES('0005','Solano','Lopez','Carlos','Jr Arequipa 213','02','csolano@yahoo.com','M','6');
INSERT INTO ALUMNO VALUES('0006','Rojas','Guzman','PEdro','Jr Puno 230','02','projas@hotmail.com','M','3');
INSERT INTO ALUMNO VALUES('0007','Vargas','Losano','Karina','Av Ugarte 30','04','kvargas@hotmail.com','F','4');
INSERT INTO ALUMNO VALUES('0008','Lopez','Roca','Ana','Jr Flores 23','03','aroca@yahoo.es','F','5');
INSERT INTO ALUMNO VALUES('0009','Garcia','Cardenas','Maria','Jr Ilo 56','05','mcardenas@hotmail.com','F','2');
INSERT INTO ALUMNO VALUES('0010','Lujan','Zapata','Carolina','Jr Tacna 356','01','czapata@yahoo.com','F','7');
INSERT INTO ALUMNO VALUES('0011','Cardenas','Hidalgo','Luisa','Av Ica 244','04','lhidalgo@hotmail.com','F','6');
INSERT INTO ALUMNO VALUES('0012','Carrillo','Rojas','Carlos','Jr Trujillo 128','11','ccarrillo@hotmail.com','M','4');
INSERT INTO ALUMNO VALUES('0013','Lopez','Garcia','Maria','Jr Palpa 314','11','mlopez@yahoo.com','F','5');