Manual
NOMBRE: Jazmín Lucio Sosa
DOCENTE: Salvador Hernández Mendoza.
CARRERA: Arquitectura de Software.
GRUPO: AS 81.
ACTIVIDAD:Evidencias del primer parcial
FECHA DE ENTREGA: Sábado 04 de Febrero del 2012.
select EmployeeIDNo from EmployeeStatisticsTable where Salary > 5000;
select * fromEmployeeStatisticsTable where Benefits between 500 and 1000;
select * from EmployeeStatisticsTable where Salary > 500 and Position=’Staff’;
select Salary from EmployeeStatisticsTable where Position!=’Staff’;
select * from EmployeeStatisticsTable where Position=’Staff’ and Position=’Manager’;
select sum(salary) as total from EmployeeStatisticsTable;
select max(salary) from EmployeeStatisticsTable;select position from EmployeeStatisticsTable where(select min(salary) as minimo from EmployeeStatisticsTable);
create data base employee;
use employee;
create tableEmployeeAddressTable(ssn varchar(20) not null,First name varchar(20) not null,last_name varchar(20) not null,address varchar(30) not null,state varchar(20) not null,city varchar(20) not null,primary key(ssn));
selectconcat(first name,’ ‘,lastname) as nombre from EmployeeAddressTable;
select * from EmployeeAddressTable where state like=’o%’;
select * from EmployeeAddressTable where city=’Howard’ andcity=’paris’;
create table departamentos(id_departamento int not null auto_increment,nombre varchar(20) not null,direccion varchar(50) not null,telefono varchar(20) not null,web varchar(20) notnull,fecha_creacion varchar(20) not null,date not null,primary key(id_departamento));
Encontrar el nombre y los dos apellidos cuyo código departamento sea 1
SELECT nombre, apPaterno, apMaterno FROM profesores WHEREIdDepartamento=1;
Hallar el nombre y los dos apellidos de los profesores de todos los departamentos excepto el de código 3
SELECT nombre, apPaterno, apMaterno FROM profesores WHERE...
Regístrate para leer el documento completo.