$1.$ Write a query $($with subquery$)$ that returns the employee$($s$)$ with the

longest last name

$2.$ Return the first and last name of the employees who have one of the $10$

most common first names in the company, using the employees table.

$3.$ Using the salaries table, find the current average salary, after removing

the $10$ lowest salaries and the $10$ highest salaries. $($Aside: in statistical

analysis, this method is also referred to as $$capping$).$

$4.$ Return the first and last name of the employees who have one of the

$10$ most common first names in the company, using the employees table.

Write this in CTE format, not in IN subquery format.