This is in MySQL. Return the names, IDS, and average salary of the top 10 employees who are Senior Engineers whose average salary is at least…

This is in MySQL. 

1. Return the names, IDS, and average salary of the top 10 employees who are Senior Engineers whose average salary is at least $110,000 in descending order.2. Find the top ten employees (names, IDs and total wages) who earned equal to or more than $200000 between 01/01/2000 and 01/01/2002. Order them in decreasing order. Assume salaries change every 12 months. For simplicity, ignore salaries that started or ended outside of the date range.3. Use a subquery to display the employee number and bottom 10 average salaries of the employees who are not ‘Staff’.