select * from EMPLOYEES;
select * from DEPARTMENTS;
select * from locations;
select job_id
from employees;
select * from DEPARTMENTS;
select department_id
from employees;
desc employees;
-- job_id este cheie primara- ESTE UNICA

/*cheie primara -> este o coloana sau o combinatie de coloane
            -> unica
            -> nu poate fi null
cheie externa-> este o coloana

            */
select * from regions;
select * from job_history;

select job_id
from jobs;
/*
la problema 8 din first lab
*/
select employee_id, last_name, salary*12 "ANNUAL SALarY"
from employees;


select employee_id, last_name, salary*12 ANNUAL_SALARY
from employees;


/*
problema 6
operator de concatenare : => ||
*/

select last_name || ' , ' || job_id
from employees;

/*
problema 7
*/

select last_name, salary
from EMPLOYEES
where salary > 17050;

/*
pb 8
*/

select last_name, department_id, employee_id
from employees
where employee_id=104;

--9
select last_name, salary
from employees
where salary not between 1500 and 2850;

select last_name, salary
from employees
where salary >=1500 and salary <=2850;