$1.$ Write a SQL statement to create a table named hr$\_$projects to store the information about the projects being run in the company. Identify to the best of your knowledge proper keys $($primary and foreign$),$ the best data types, and any other constraint that should be considered. The table must comprise the following attributes:

project$\_$number: number of the project, it must allow to identify each project uniquely by using this identifier.

project$\_$name: name of the project, it cannot be null.

project$\_$manager: identifies the project manager, it must be one of the existing employees.

project$\_$department: identifies the project department, it must be one of the existing departments.

project$\_$budget: budget of the project $($USD currency format$).$

$2.$ Write a SQL statement to:

Insert yourself as a new employee in the Employees table. Include only your employee$\_$id $(1234),$ last$\_$name $($your lastname$),$ email $($your email$),$ hire$\_$date $($now as in the system$$s date$),$ and job$\_$id $($IT$\_$PROG$).$ Do not include any other information nor NULL values in the insert statement.

Update your salary and set it to $80,000.$

Delete yourself from the Employees table $($you$$re fired!$).$

$3.$ Write a query to show the distinct last names of the employees and how many of them have such same last name, sort the results according to the count first $($bigger count first$),$ and in case of equal count then sort according to the alphabetical order $($A first, Z last$).$

$4.$ Write a query to show the full name of the employees in a single column $($e$.$g$.$ John Doe$),$ the department name, and the location $($city$)$ for all employees whose job title contains Manager and does not contain Sales.

$5.$ Write a query to show the department name, the department$$s manager full name in a single column $($e$.$g$.$ John Doe$),$ the average salary of all employees working for the department, and the number of employees of the department. Show only the departments whose manager$$s salary is more than $10,000.$