Upload
ajikan23
View
224
Download
1
Embed Size (px)
DESCRIPTION
sql basico
Citation preview
SQL BASICO
Mediante cdigo SQL desarrollar lo siguiente:
Crear una tabla llamada ALUMNO con los siguientes
1. Campos (cdigo, nombre y apellido, direccin, email, fecha de Nacimiento, distrito, pensin)
2. Mediante sentencias SQL llenar datos (10 registros) a la tabla creada (ALUMNO)INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("CARRILLO","CAMPOS","JULIA NORA","AV MANZANO 555","TACNA","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA ROSA","AV CANADA 8775","COMAS","1985-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","COMAS","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","LINCE","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","LINCE","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","BARRANCO","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","CHORRILLOS","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","LINCE","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","COMAS","1970-05-01","180.58","[email protected]")
INSERT INTO ALUMNO
(alu_paterno,alu_materno,alu_nombres,alu_direccion,alu_distrito,alu_fecnac,alu_pension,alu_correo)
VALUES ("LOPEZ","ROBERTO","ISIDORA NORA","AV CANADA 8775","LINCE","1970-05-01","180.58","[email protected]")
3. Mostrar los alumnos que nacieron en la dcada de los 80 y que son De COMAS o LINCE (Aplique SELECT) SELECT * FROM ALUMNO WHERE ALU_DISTRITO="LINCE" AND YEAR(ALU_FECNAC)=1980
SELECT * FROM ALUMNO WHERE ALU_DISTRITO="COMAS" AND YEAR(ALU_FECNAC)=1980
4. Mostrar los alumnos que se apelliden GARCIA (no importa si es su Primer apellido o el segundo) y que su pensin este entre 300 y 500.
SELECT * FROM ALUMNO WHERE (ALU_PATERNO="GARCIA" OR ALU_MATERNO="GARCIA") AND (ALU_PENSION BETWEEN 300 AND 500)