Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- BD MARCAS
- -- 1
- SELECT nombre AS 'nombre_de_producto', precio AS 'precio_de_producto',
- CASE
- WHEN precio > 10000 THEN 'Muy costoso'
- WHEN precio > 5000 THEN 'Costoso'
- ELSE 'Normal'
- END AS 'clasificacion_por_precio'
- FROM productos
- ORDER BY precio;
- -- 2
- SELECT nombre AS 'nombre_de_producto', puntuacion AS 'puntuacion_de_producto',
- CASE
- WHEN puntuacion > 8 THEN 'MUY BUENO'
- WHEN puntuacion > 6 THEN 'BUENO'
- ELSE 'REGULAR'
- END AS 'clasificacion_por_puntuacion'
- FROM productos
- ORDER BY puntuacion;
- -- BD HOSPITAL
- -- 3
- SELECT apellido, salario, oficio, Fecha_Alt AS 'fecha_de_alta',
- CASE
- WHEN Dept_No != 10 AND Dept_No != 30 THEN 'mantener'
- ELSE 'eliminar'
- END AS 'reestructuracion'
- FROM emp;
- -- 4
- (SELECT apellido,
- CASE
- WHEN Salario < 100000 THEN 'SUBIR SUELDO'
- WHEN Salario > 250000 THEN 'BAJAR SUELDO'
- ELSE 'MANTENER'
- END AS 'recorte_salarial'
- FROM emp)
- UNION
- (SELECT apellido,
- CASE
- WHEN Salario < 100000 THEN 'SUBIR SUELDO'
- WHEN Salario > 250000 THEN 'BAJAR SUELDO'
- ELSE 'MANTENER'
- END AS 'recorte_salarial'
- FROM plantilla)
- ORDER BY apellido;
- -- 5
- SELECT apellido,
- CASE
- WHEN T = 'T' THEN 'TARDE'
- WHEN T = 'N' THEN 'NOCHE'
- ELSE 'OTROS'
- END AS turno_laboral
- FROM plantilla
- ORDER BY Apellido;
- -- 6
- SELECT apellido, direccion, ((CAST(RIGHT(fecha_nac, 2) AS INT) DIV 10)*10) AS 'decada_de_naciemiento',
- CASE
- WHEN S = 'M' THEN 'MASCULINO'
- ELSE 'FEMENINO'
- END sexo
- FROM enfermo;
- -- 7
- SELECT DISTINCT apellido, salario, oficio, emp.Dept_No AS 'nΒΊ_de_dpto', comision,
- CASE
- WHEN emp.Dept_No = NULL THEN 'NO TIENE'
- ELSE 'TIENE'
- END AS 'disponibilidad_de_dpto',
- CASE
- WHEN emp.Comision > 0 THEN 'SI'
- ELSE 'NO'
- END AS 'tiene_comision'
- FROM emp
- LEFT JOIN dept ON emp.Dept_No IN (SELECT dept.Dept_No FROM dept)
- ORDER BY apellido;
- -- 8
- SELECT hospital.Nombre AS 'hospital', sala.Nombre AS 'sala', sala.Num_Cama AS 'nΒΊ_de_camas',
- CASE
- WHEN sala.Num_Cama < 1 THEN '0'
- WHEN sala.Num_Cama > 90 THEN 'MUCHAS CAMAS'
- WHEN sala.Num_Cama > 40 THEN 'BUEN NUMERO DE CAMAS'
- ELSE 'POCAS'
- END AS 'cant_de_camas'
- FROM hospital LEFT JOIN sala ON hospital.Hospital_Cod = sala.Hospital_Cod;
- -- BD CONTACTOS
- -- 9
- SELECT DISTINCT CONCAT(nombre, ' ', apellidos) AS 'Empleado',
- CASE
- WHEN localidad = 'Barcelona' THEN 'SI'
- ELSE 'NO'
- END AS 'cambiaria_de_localidad'
- FROM contactos
- ORDER BY apellidos;
- -- 10
- SELECT DISTINCT CONCAT(nombre, ' ', apellidos) AS 'nom_y_ape',
- CASE
- WHEN sexo = 'M' THEN 'SI'
- ELSE 'NO'
- END AS 'es_hombre',
- CASE
- WHEN altura > 1.75 THEN 'SI'
- ELSE 'NO'
- END AS 'es_alt@'
- FROM contactos;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement