Ingeniero De Sistemas

PRACTICA 1

1. select employee_id, last_name, job_id,hire_date as StartDate from employees;
2. select distinct JOB_ID from employees;
3. select *from employees
4. select employee_id as "Emp#",last_name as "Employee", job_id as "Job", HIRE_DATE as "Hire DAte" from employees;
5. Select last_name||', '||job_id as "Employee and Title" from employees;
6. SELECTemployee_id||','||first_name||','||last_name||','||email||','||phone_number||','||hire_date||','||job_id||','||salary||','||commission_pct||','||manager_id||','||department_id as "THE_OUTPUT" from employees;

PRACTICA 2

1.SELECT last_name, salary from employees WHERE salary>12000
2. SELECT last_name, department_id from employees WHERE employee_id='176'
3. SELECT last_name, salary from employees WHERE salary <5000or salary > 12000
4. SELECT last_name, job_id, hire_date FROM employees WHERE last_name='Matos' or last_name='Taylor' ORDER BY hire_date
5. SELECT last_name, department_id from employees wheredepartment_id='20' or department_id='50' order by last_name asc
6. SELECT last_name as "Empelado", salary as "Sueldo por mes" from employees WHERE salary between 5000 and 12000 and(department_id='20' or department_id='50');
7. SELECT last_name, TO_CHAR(hire_date, 'DD-Mon-yyyy') FROM employees WHERE TO_char(hire_date, 'yyyy')='1994';
8. select last_name,job_id from employees WHERE manager_id isNULL;
9. Select last_name,salary, commission_pct from employees where commission_pct is not null
10. SELECT last_name,salary from employees where salary>&sueldo;
11. SELECT employee_id,last_name,salary,department_id from employees WHERE manager_id=&codigo ORDER BY employee_id
12. SELECT last_name from employees WHERE last_name like'__a%'
13. SELECT last_name from employees WHERElast_name like'%a%' and last_name like'%e%';
14. SELECT last_name,job_id,salary from employees WHERE job_id='SA_REP' or job_id='ST_CLERK' and salary!=2500 and salary!=3500 and salary!=7000;
15....