Sentencias bd
From Sucursales as S, Empresa as W.
Where S.Cedula_Juridica = W.Cedula_Juridica and W.Razon_Social = “El Banco Feliz”
2) Select W.Razon_SocialFrom Empresa as W
3) Select E.Nombre
From Empleados as E, Sucursales as S, Empresa as W
Where E.Cod_Sucursal = S.Cod_Sucursal and S.Cedula_Juridica = W.Cedula_Juridica andW.Razon_Social = “El Banco Feliz”
4) Select R.Descripcion
From Servicios as R, Empresa as W, ServiciosxEmpresa as RxW.
Where W.Razin_Social = “Diente Alegre” and W.Cedula_Juridica =SxE.Cedula_Juridica and RxW.Cod_Servicio = R.Cod_Servicio and R.Costo > 10 000
5) Select C.Nombre
From Clientes as C, ClientexServicio as CxR, Servicios as R.
Where C.ID_Cliente =CxR.ID_Cliente and CxR.Cod_Servicio = R.Cod_Servicio and R.Descripcion = “Blanqueamiento”.
6) Select E.Nombre
From Empleado as E, Sucursales as S.
Where E.Cod_Sucursal =S.Cod_Sucursal and S.Provincia = “San Jose”.
7) Select T.Telefono
From Tel_Clientes as T, Clientes as C.
Where T.ID_Cliente = C.ID_Cliente and C.ID_Cliente = “25”
8) SelectS.nombre, S.Provincia, S.telefono
From Sucursales as S, Empresa as W.
Where S.Cedula_Juridica = W.Cedula_Juridica and W.Razon_Social = “El Zapatito”
9) Select W.Ced_JuridicaFrom Empresa as W.
Where W.Mercado = “Financiero” or W.Mercado = “Salud”.
10) Select E.Nombre
From Empleados as E.
Where E.Area = “Cobros”
11) Select E.NombreFrom Empleados as E, Sucursales as S, Empresa as W.
Where E.Cod_Sucursal = S.Cod_Sucursal and S.Cedula_Juridica = W.Cedula_Juridica and W.Mercado = “Salud”
12) SelectR.Descripcion
From Servicios as R.
13) Select R.Descripcion
From Servicios as R.
Where R.Costo < 50 000
14) Select R.Descripcion
From Servicios as R,...
Regístrate para leer el documento completo.