write a SP with department number as parameter, a percentage as another parameter, and a count as an output parameter, increase budgets of projects (controlled by the department) by the specified percentage and find out number of unique employees working for projects controlled by the department.
write a SP with a project number as parameter, list(select) the department that controls the project, and list (select) other projects controlled by the same department.
write a SP, given a project number as parameter, return the number of unique job title of this project as an output parameter, and the number of unique job title of the project's workers in other projects as another output parameter.
Submit an article or tip