Division (DID, dname, managerID) Employee (emplD, name, salary, DID) Project (PID, pname, budget, DID) Workon (PID, EmpID, hours)

Division (DID, dname, managerID)<br>Employee (emplD, name, salary, DID)<br>Project (PID, pname, budget, DID)<br>Workon (PID, EmpID, hours)<br>

Extracted text: Division (DID, dname, managerID) Employee (emplD, name, salary, DID) Project (PID, pname, budget, DID) Workon (PID, EmpID, hours)

a6 Create a table Promotion_list (EMPID, Name, Salary, DivisionName).<br>a7 Load Promotion_list with the information of employees who make less than company average and work on at least 2 projects. (Hint use INSERT INTO SELECT statement ). Show the code<br>and result.<br>

Extracted text: a6 Create a table Promotion_list (EMPID, Name, Salary, DivisionName). a7 Load Promotion_list with the information of employees who make less than company average and work on at least 2 projects. (Hint use INSERT INTO SELECT statement ). Show the code and result.

Jun 08, 2022

SOLUTION.PDF

Division (DID, dname, managerID) Employee (emplD, name, salary, DID) Project (PID, pname, budget, DID) Workon (PID, EmpID, hours)

Get Answer To This Question

Related Questions & Answers

Submit New Assignment