Ist Lab 5

IST210 Lab 5. 7/19/09 1. Display the employee_id, last_name, subdivision_id and the name of the discussion section (the name will come from the demo_department table) for all employees. You will summation department and employee. SELECT employee_id, last_name, name FROM demo_employee, demo_department WHERE demo_employee.department_id = demo_department.

department_id; employee_id last_name name --------------------------------------- --------------- -------------- 7369 SMITH investigate 7499 ALLEN SALES 7505 DOYLE SALES 7506 DENNIS SALES 7507 BAKER operations 7521 wrap SALES 7555 PETERS SALES 7557 SHAW SALES 7560 DUNCAN SALES 7564 LANGE SALES 7566 JONES search 7569 ALBERTS RESEARCH 7600 PORTER SALES 7609 ! LEWIS OPERATIONS 7654 MARTIN SALES 7676 SOMMERS OPERATIONS 7698 BLAKE SALES 7782 CLARK ACCOUNTING 7788 SCOTT RESEARCH 7789 WEST SALES 7799 fisher cat RESEARCH 7820 ROSS SALES 7839 KING ACCOUNTING 7844...If you want to lounge about a full essay, order it on our website: Best EssayCheap.com

If you want to get a full essay, visit our page: cheap essay