Week 06 Lab Total Score: 5 points per question (total 55 points) Due Date: Monday, February 24, 2020 by 11:00 PM 3. Create a query to display all employee data from deptua column, egame column, and employee's colleague name from the emptable Lutery results should be displayed as below) Dept ID Emp Nane Coll Name 1. Write a query to display all employee data from cane column, detto,column, and doame column from the emp athle and dept table. 5. Write a query to display all employee data from ante column, job column, desto column, and doare.column from the emptable and dept table Please only display employees who work in DALLAS ACCOUNTING RRRRRRRRRRR ESENTING ENAME ONES JOB MANAGER DEPTNO DNAME SAH SEST Dept ID ANALYST DEPTNO DRAME 6. Write a query to display all employee data from ampoo column.ename column, met column, and manager name using self-join from the emptable ( ery results should be displayed as below) Create a unique listing of all jobs that are in desto 30. Includes loc's data of destro, So the output E ID Em Nane Mer IDM None SRS 9. Create a query to display all employee data from eamdecolumn.job column, donde column. al column, and grade column from the emptable and selerade table query results should be displayed as below) SAL DNAME GRADE Mer ID Mar Name EM 10 En Nane ZM2 NIIN SELECT DISTINCT jobuoc FROM empod WHEN 30 fotodete and SLERS MAN 7. Please upgrade the question 6's query to display result includes employee KING from the emptable. Comery results should be displayed as below) ANALYST 3. Write a query to display all employee data from etame column, dusse column, and loc column from the empathle and dept table. Please only display employees who have earned commissions inside com column ENAME SAL ONAME GRADE Emp ID Em None Mar 1D Mar Nane cat ENAME NAME 10. Create a query to display all employee data from eande column, and hirestate columns from the emptable. Please use join to display employees who were hired after employee BLAKE (Ouery results should be displayed as below) 52 JONES Mgr ID Mgr Nase to 4. Write a query to display all employee data from ease column and duane column from the emptable and dept table. Please only display employees who have at least an A and R in their name Emp ID Emp Nane 29 SMITH 2 11. Write a query to display all employee data from ecame column. biredate.column, and manager name, and manager's birdate using self-join from the emptable. The employees must be hired before Their manager (query results should be displayed as below) Emp Name Emp Hired Mer Name Mar Hired 1225E-8 EBD