ans this plz

Question 6 (5 points) Based on Appendix A Write a select statement that return the employee ld of the employees who work in purchasing department (purchasing is a department name and it is departments table) Appendix A - HR Tables ciba Countries * EMPLOYEE D P bart met malo) TEST NAME (50. muilty LAST NAME achei mulle Parcuri mult PHONE NUMBER 1. multe 2 HORE DATE date, null) Dr. abo Departments Columns DEPARTMENT D PK bigint, met nullo D DEPARTMENT NAME anchan(250 MM MANAGER D (bigint, nullo D LOCATION D bigint, mit Region Din, dbetector dba Regions CONPT D. Mula IMAORD (guant, ut DEPARTMENT D liglet, muit) 13 CD Dot no cha Minist Me