$1.[2$ pt$]$ Write a query to retrieve the first and last names of all employees along with the names of the departments

they belong to$.$

$2.[2$ pt$]$ Write a query to list all employees and the projects they are working on$.$ Include employees who are not

assigned to any project.

$3.[2$ pt$]$ Write a query to find the total hours worked by each employee on each project.

$4.[2$ pt$]$ Write a query to find the total budget allocated for projects in each department.

$5.[2$ pt$]$ Write a query to list the employees and categorize their salary as 'High', 'Medium', or 'Low'. Assume

$`$High$`$ is above $70000,`$Medium$`$ is between $40000$ and $70000,$ and $`$Low$`$ is below $40000.$

$6.[2$ pt$]$ Write a query to find the average salary of employees in each department.

$7.[3$ pt$]$ Write a query to display each employee's name and their project status. The project status should be

'Assigned' if they have a project and 'Unassigned' otherwise.