USE ProjectManagement;

$/*1.$ Generate the list of all managers $($showing the manager number and manager name, in that order$)$

for which each manager number includes the character zero. Sort the result in descending order of manager name.$*/$

$/*2.$ Generate the list of all manager numbers of the projects that are over budget $($i$.$e$.,$ the projects

for which the actual cost exceeds the expected cost$).$ Do not include duplicate manager numbers.$*/$

$/*3.$ Generate a list of all managers $($showing the manager name and manager number$)$ who work in

the Finance department. List the names in inverse alphabetical order.$*/$

$/*4.($difficult one!$)$ List the project name and expected cost for the projects that have an expected cost

greater than the average expected cost for all projects. $($Hint: Use a nested query.$)*/$

$/*5.$ Calculate the average expected cost for all projects managed by the manager named Yates.

$($Assume that you do not know Yates$$ number.$)*/$

$/*6.$ Calculate the total actual cost for all projects not over$-$budgeted managed by Kanter.$*/$

$/*7.$ List all managers $($include there name, number, and department$)$ for those who have

managed projects. $*/$

$/*8.$ List all managers $($include there name, number, and department$)$ for those who have

managed projects and those who have not. Display in a single result set.

$($Hint: use a left or right join this time!$).*/$