dnes rano o 7:30 sme pisali pisomku s Telepovskou za 4 body vraj...otazky nemam ale tu su odpovede...dufam ze pomoze
SKUPINA A
1.)
select last_name,phone_number
from hr.employees
where phone_number like '515%'
2.)
select * from hr.locations
where state_province is null
3.) + prepisat do relacnej algebry
select last_name,salary*commission_pct
from hr.employees
where (salary + salary*commission_pct) > 10000
order by last_name
SKUPINA B
1.)
select * from hr.locations
where postal_code is not null
2.)
select job_title,min_salary,max_salary
from hr.jobs
where job_title like '%Representative%'
order by job_title
3.) + prepisat do relacnej algebry
select last_name, hire_date
from hr.employees
where hire_date > '31.12.1995'