SELECT * 


FROM countries

____________________________

SELECT country_id, country_name, region_id


FROM countries

________________________________________

SELECT country_id, country_name, region_id


FROM countries

where country_name LIKE 'I%'

order by region_id 

_______________________________

SELECT c.country_id, c.country_name, c.region_id,
r.region_id, r.region_name, count(r.region_id) as Kogus


FROM countries as c, regions as r

where c.region_id=r.region_id

group by r.region_id

order by c.region_id 

___________________________________

SELECT j.job_id, j.job_title, j.max_salary, j.min_salary ,
e.last_name, e.employee_id, e.job_id, round(avg(e.salary),2) as 'Keskmine palk', e.department_id


from jobs as j, employees as e

where j.job_id=e.job_id

group by e.job_id

order by e.salary DESC

_________________________________

praktikumi ülesanded (word document)
3.

SELECT DISTINCT job_title, min_salary

from jobs
where min_salary<5000

___________________________
4.


SELECT DISTINCT job_title, min_salary

from jobs
where min_salary<50000 and min_salary>=10000

________________________________________

SELECT DISTINCT job_title, min_salary

from jobs
where min_salary between 10000 and 50000

_______________________________________________
5.

SELECT department_id, department_name

FROM departments

where department_id between 10 and 30

_______________________________________
6.

select e.last_name, j.job_title, e.salary, j.min_salary, j.max_salary, j.job_id

from employees as e, jobs as j

where
(j.job_id LIKE'%CLERK' OR j.job_id='SA_REP')
and
e.salary between 3000 and 8000
and
e.job_id=j.job_id

__________________________________