Pertemuan 2

SELECT last_name, job_id, department_id

FROM employees

WHERE last_name = 'Whalen';

SELECT last_name, salary

FROM employees

WHERE salary <= 3000;

SELECT last_name, salary

FROM employees

WHERE salary BETWEEN 2500 AND 3500;

SELECT employee_id, last_name, salary, manager_id

FROM employees

WHERE manager_id IN (100, 101, 201);

SELECT first_name

FROM employees

WHERE first_name LIKE 'S%';

LATIHAN PERTEMUAN 2

SOAL NO. 1

Tampilkan First Name, Last Name, Dan Salary dari pegawai yang gajinya

SELECT first_name, last_name, salary

FROM employees

WHERE salary BETWEEN 1500 AND 4000;

SOAL NO. 2

SELECT  first_name ||' '|| last_name

AS "Nama Lengkap", salary

FROM employees

WHERE manager_id NOT IN (120, 201);

SELECT employee_id, last_name, job_id, salary

FROM employees

WHERE salary >=10000

AND job_id LIKE '%MAN%';

SELECT employee_id, last_name, job_id, salary

FROM employees

WHERE salary >=10000

OR job_id LIKE '%MAN%';

SELECT last_name, job_id

FROM employees

WHERE job_id NOT IN ('IT_PROG', 'ST_CLERK', 'SA_REP');

SELECT last_name, job_id, salary

FROM employees

WHERE job_id = 'SA_REP'

OR job_id = 'AD_PRES'

AND salary > 15000;

SELECT last_name, job_id, department_id, hire_date

FROM employees

ORDER BY hire_date;

SELECT last_name, job_id, department_id, hire_date

FROM employees

ORDER BY hire_date DESC;

SELECT employee_id, last_name, salary*12 annsal

FROM employees

ORDER BY annsal;

SELECT last_name, department_id, salary

FROM employees

ORDER BY department_id, salary DESC;

LATIHAN PERTEMUAN 2

SOAL NO. 3

Tampilkan nama pegawai, salary, job id dari pegawai yang gajinya lebih besar dari 5000 dan job idnya mengandung kata “REP” :

SELECT first_name, last_name, salary, job_id

FROM employees

WHERE salary > 5000

AND  job_id  like '%REP%'

SOAL NO. 4

Tampilkan nama pegawai, job id dari pegawai yang job idnya mengandung kata IT dan ST :

SELECT first_name, last_name, job_id

FROM employees

WHERE job_id like '%IT%'

OR job_id like '%ST%';

SELECT employee_id, last_name, department_id

FROM employees

WHERE LOWER(last_name)='higgins';