-- MARKET KATEGORİNDEKİ MÜŞTERİLERİ LİSTELE
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE DEPARTMENT_ID=
(SELECT DEPARTMENT_ID FROM DEPARTMENTS  WHERE DEPARTMENT_NAME='Marketing')

-- AYNI İŞLEMİ JOİNLE YAPMA
SELECT * FROM EMPLOYEES E

JOIN DEPARTMENTS  D ON E.DEPARTMENT_ID=D.DEPARTMENT_ID  AND D.DEPARTMENT_NAME='Marketing'