Question: Provide the code in SQL workbench: For the manager table, show the columns managerid, mfname, mlname, and a column showing the sum of msalary and
Provide the code in SQL workbench:
For the manager table, show the columns managerid, mfname, mlname, and a column showing the sum of msalary and mbonus for each manager who receives a bonus.
Like this:
SELECT managerid, mfname, mlname, msalary, mbonus FROM manager GROUP BY managerid HAVING SUM(msalary+mbonus);
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
