Q0: | SELECT | FNAC, DIRECCION |
FROM | EMPLEADO | |
WHERE | NPILA = "Juan" AND APPAT = "Pérez" |
Q1: | SELECT | NPILA, APPAT, DIRECCION |
FROM | EMPLEADO, DEPARTAMENTO | |
WHERE | DNOMBRE = "Investigación" AND DNUMERO = NDEPTO |
Q2: | SELECT | PNUMERO, DNUM, NPILA, APPAT, DIRECCION, FNAC |
FROM | PROYECTO, DEPARTAMENTO, EMPLEADO | |
WHERE | DNUM = DNUMERO AND RUTGERENTE = RUT AND PUBICACION = "La Florida" |
Q1A: | SELECT | EMPLEADO.NOMBRE, APPAT, DIRECCION |
FROM | EMPLEADO, DEPARTAMENTO | |
WHERE | DEPARTAMENTO.NOMBRE = "Investigación" AND DEPARTAMENTO.DNUMERO = EMPLEADO.DNUMERO |
Q3: | SELECT | E.NPILA, E.APPAT, S.NPILA, S.APPAT |
FROM | EMPLEADO E, EMPLEADO S | |
WHERE | E.RUTSUPERV = S.RUT |
Q4: | SELECT | RUT |
FROM | EMPLEADO |
Q5: | SELECT | RUT, DNOMBRE |
FROM | EMPLEADO, DEPARTAMENTO |
Q6: | SELECT | * |
FROM | EMPLEADO | |
WHERE | NDEPTO = 5 |
Q7: | SELECT | * |
FROM | EMPLEADO, DEPARTAMENTO | |
WHERE | DNOMBRE = "Investigación" AND NDEPTO = DNUMERO |
Q8: | SELECT | * |
FROM | EMPLEADO, DEPARTAMENTO |
Q9: | SELECT | SUELDO |
FROM | EMPLEADO |
Q9A: | SELECT | DISTINCT SUELDO |
FROM | EMPLEADO |
Q10: | ( SELECT | PNUMERO |
FROM | PROYECTO, DEPARTAMENTO, EMPLEADO | |
WHERE | DNUM = DNUMERO AND RUTGERENTE = RUT AND APPAT = "Pérez" ) | |
UNION | ||
( SELECT | PNO | |
FROM | TRABAJA_EN, EMPLEADO | |
WHERE | ERUT = RUT AND APPAT = "Pérez" ) |