Find the IDs and names of the employees whose salaries are at least 10% higher than the average salary of all employees
Using a simple subquery should help with this:

SELECT e.eid, CONCAT(efirstname, ' ', e.elastname) name
FROM employees e
WHERE e.salary &gt; (SELECT AVG(salary) FROM employees) * 1.10