1. Listado de todos los miembros del personal cuyo nombre empiece por la letra 'A'.
Consultas SQL 3er Parcial 2°A CBT3

Quiz
•
Instructional Technology
•
2nd Grade
•
Hard
CRISTINO BANDALA
Used 13+ times
FREE Resource
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
SELECT nombre
FROM sala WHERE apellido LIKE 'A%';
SELECT apellido
FROM plantilla WHERE apellido LIKE 'A%';
SELECT nombre
FROM hospitales WHERE apellido LIKE 'A%';
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
2. ¿Quiénes son las enfermeras y enfermeros que trabajan en turnos de Tarde o Mañana?
SELECT apellido
FROM enfermo
WHERE apellido= ('ENFERMERO','ENFERMERA');
SELECT nombre
FROM sala
WHERE funcion IN ('ENFERMERO','ENFERMERA')
AND turno IN ('T','M');
SELECT apellido
FROM plantilla
WHERE funcion IN ('ENFERMERO','ENFERMERA')
AND turno IN ('Tarde','Mañana');
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
3. Listado de las enfermeras que ganan entre 20,000 y 25,000 MXN.
SELECT apellido, salario
FROM plantilla
WHERE salario BETWEEN 20000 AND 25000
AND funcion = 'ENFERMERA'
SELECT apellido, nss
FROM enfermo
WHERE salario BETWEEN 2000000 AND 2500000
AND funcion = 'ENFERMERAS';
SELECT apellido, salario
FROM sala
WHERE salario BETWEEN 200000 AND 250000
AND funcion = 'ENFERMERA';
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
4. Mostrar, para todos los hospitales, el código de hospital, el nombre completo del hospital y su nombre. Ordenar la recuperación por el nombre.
SELECT nom, hospital_cod
FROM hospital
ORDER BY nom DESC;
SELECT nombre, hospital
FROM hospital
ORDER BY 1;
SELECT nombre, hospital_cod
FROM hospital
ORDER BY nombre ASC ;
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
5. Se desea conocer el máximo salario que existe en cada sala de cada hospital.
SELECT MAX (salario)
FROM sala AS s, plantilla p, hospital AS h
WHERE h.hospital_cod = p.hospital_cod
GROUP BY h.nombre, s.nombre;
SELECT hospital.nombre, sala.nombre, MAX (salario)
FROM , plantilla, hospital
WHERE h.hospital_cod = p.hospital_cod;
SELECT h.nombre, s.nombre, MAX (salario)
FROM sala AS s, plantilla p, hospital AS h
WHERE h.hospital_cod = p.hospital_cod
AND p.sala_cod = s.sala_cod
GROUP BY h.nombre, s.nombre;
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
6. Recuperar el número (empleado_no) y nombre de las personas que perciban un salario mayor que la media de su hospital.
SELECT empleado_no
FROM plantilla p
WHERE salario > ( SELECT AVG (salario)
FROM sala
WHERE p2.hospital_cod = p.hospital_cod );
SELECT apellido, empleado_no
FROM plantilla p
WHERE salario > ( SELECT AVG (salario)
FROM plantilla p2
WHERE p2.hospital_cod = p.hospital_cod );
SELECT apellido, empleado_no
FROM plantilla p
WHERE salario > ( SELECT AVG (salario)
FROM plantilla p2
WHERE p2.hospital_cod = p.hospital_cod );
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
7. Insertar en la tabla Plantilla al enfermero Garcia J. con un sueldo de 30,000 MXN, y número de empleado 1234. Trabaja en el hospital 22, sala 2, turno matutino.
INSERT INTO
VALUES (22,2,1234,'Garcia J.','ENFERMERO', 'M',30000);
INSERT INTO plantilla
VALUES (22,2,1234,'Garcia J.','ENFERMERO','M',30000);
INSERT INTO plantilla(hospital_cod, sala_cod, empleado_no, apellido,
funcion, turno, salario)
Create a free account and access millions of resources
Similar Resources on Quizizz
9 questions
Aprendizaje Significativo

Quiz
•
KG - University
12 questions
Proceso general de un trabajo estadístico

Quiz
•
1st - 2nd Grade
10 questions
Grupo Primario Gerencia Marzo/2020

Quiz
•
1st Grade - Professio...
8 questions
What is an engineer

Quiz
•
1st - 3rd Grade
7 questions
PRIMEROS AUXILIOS

Quiz
•
2nd Grade
8 questions
AV 30

Quiz
•
2nd Grade
7 questions
DERECHO LABORAL Y SEGURIDAD SOCIAL

Quiz
•
1st Grade - University
9 questions
Paint - Clase 10 de Abril

Quiz
•
2nd Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade