Manual

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...