DORDB ukol

-- 1)
SELECT e.last_name AS PRIJMENI
FROM employees e
WHERE SUBSTR(e.last_name,0,1) = 'B'
ORDER BY e.last_name;

-- 2)
SELECT e.first_name AS JMENO, e.last_name AS PRIJMENI, e.salary AS PLAT
FROM employees e
WHERE e.job_id = e.job_id AND e.job_id='AD_PRES';

-- 7)
SELECT e.first_name AS JMENO, e.last_name AS PRIJMENI
FROM employees e
join jobs j
ON e.job_id = j.job_id
WHERE j.job_title = 'Programmer'
    OR j.job_title = 'Human Resources Representative'
    OR j.job_title = 'Sales Manager'
ORDER BY e.last_name

-- 8)
SELECT e.first_name AS JMENO, e.last_name AS PRIJMENI, e.hire_date AS NASTUP
FROM employees e
join departments d ON e.department_id = d.department_id
join locations l ON l.location_id = d.location_id
WHERE l.state_province = 'California'
    AND TO_CHAR(e.hire_date, 'YYYY') >= 1999
ORDER BY e.hire_date DESC