$3.$For $4$points$,$ list all the employee information, along with average salary earned by each employee. Hint: use lgemployee & lgsalary

$\_$history tables.

$5.$For $2\mathrm{.}5$points$,$ list all the employee information, along with average salary earned by each employee. You must use only lgemployee table and fn

$\_$GetAvgSalary that was created in the previous step.

$6.$ For$4$ points, list all the information about departments, along with average salary earned within each department. Hint: use lgdepartment & lgsalary

history tables.

$7.$For $2\mathrm{.}5$points$,$ list all the information about departments, along with average salary earned within each department. You must use only lgdepartment table and fn

$\_$GetAvgSalary that was created earlier.