171095_lab2.txt

Gwidon JóŸwiak 171864
2. 
TRUE

4.1
DESCRIBE DEPARTMENTS;
4.2
SELECT * FROM DEPARTMENTS;

5.1
DESCRIBE EMPLOYEES;
5.2
SELECT last_name, job_id, hire_date, employee_id FROM employees;

6
success

8
SELECT last_name as "Emp #", job_id as "Job" , hire_date as "Hire Date", employee_id as "Employee" FROM employees ;

10
SELECT last_name ||': 1 Month salary ='|| salary FROM employees ;

12
SELECT last_name , department_id FROM employees WHERE employee_id=176 ;

14
SELECT last_name , job_ID , hire_date FROM employees WHERE  hire_date between '98/02/20' and '98/05/01' ;

16
SELECT last_name as "Employee" , salary as "Monthly Salary" FROM employees 
	WHERE  (salary between 5000 and 12000) and (DEPARTMENT_ID between 20 and 50) ;

18
SELECT LAST_NAME, JOB_ID FROM employees WHERE MANAGER_ID is NULL ;

20
SELECT LAST_NAME FROM employees WHERE LAST_NAME like '__a%' ;

22
SELECT LAST_NAME, JOB_ID, SALARY FROM employees 
	WHERE (JOB_ID like 'ST_CLERK'  or JOB_ID like 'SA_REP') and (SALARY!=2500 and SALARY!=3500 and SALARY!=7000);

Czêœæ II
2
SELECT EMPLOYEE_ID, LAST_NAME, SALARY, REPLACE(SALARY, SALARY, SALARY*1.15) as "NEW SALARY"  FROM employees;

4
SELECT initcap(LAST_NAME) as "Name" , LENGTH(Last_Name) AS "Lenght"  FROM employees 
	WHERE Substr(LAST_NAME, 1,1) IN ('J', 'A', 'M');

6
SELECT LAST_NAME, HIRE_DATE, TO_CHAR(HIRE_DATE, 'DAY') AS DAY FROM EMPLOYEES ORDER BY TO_CHAR(HIRE_DATE, 'D')