FUNGSI AGGREGATE

SELECT MIN(hire_date)AS tgl_tertua FROM employees

SELECT MAX(hire_date)AS tgl_termuda FROM employees

SELECT AVG(salary)AS rata_gaji FROM employees

SELECT SUM(salary)AS total_gaji FROM employees

SELECT COUNT(job_id)AS total_peg FROM employees WHERE job_id='IT_PROG'

SELECT COUNT(job_id)AS total_peg FROM employees WHERE job_id='FI_ACCOUNT'

SELECT a.employee_id,a.last_name,b.department_name FROM employees a, departments b WHERE a.department_id=b.department_id

SELECT a.employee_id,a.first_name,b.job_title FROM employees a,jobs b WHERE a.job_id=b.job_id