/* Kdo je najbolje plačani zaposlen ? */

SELECT FIRST 1 (SALARY), FULL_NAME FROM EMPLOYEE
order by SALARY descending














/* izračunaj povprečne in maksimalne plače po oddelkih */

SELECT  MAX(EMPLOYEE.SALARY), AVG(EMPLOYEE.SALARY), DEPARTMENT.DEPT_NO FROM  EMPLOYEE
INNER JOIN DEPARTMENT ON (EMPLOYEE.DEPT_NO = DEPARTMENT.DEPT_NO)
GROUP BY DEPARTMENT.DEPT_NO

















/* Izpiši zapolene, ki sodelujejo v vsaj enem projektu  - uporabi vgnezdeno poizvedbo
   Uporabi tabele employee, employee_project */

SELECT EMPLOYEE_PROJECT.EMP_NO,  EMPLOYEE.LAST_NAME FROM EMPLOYEE
INNER JOIN EMPLOYEE_PROJECT ON (EMPLOYEE_PROJECT.EMP_NO = EMPLOYEE.EMP_NO)
ORDER BY EMPLOYEE.EMP_NO ASCENDING