MySQL Code Challenges & Tips

1. Write a query to find the second highest salary from the Employee table.

2. Write a SQL statement to retrieve the names of employees who earn more than their manager.

3. Write a query to count the number of employees in each department, returning the department name and the employee count.

4. Write a SQL query to retrieve the top 3 highest-paid employees from the Employee table, along with their department.

5. Create a view named `ActiveEmployees` that shows all employees who have been hired in the last year.

6. Write a query to find all products that have never been ordered from the Orders table.

7. Write a query to update the salary of all employees by 10% who have been with the company for more than 5 years.

8. Write a query to find the average salary of employees in each job role, sorted by the average salary in descending order.

9. Write a SQL statement to return the employee ID and name of employees who share the same job title as another employee in a different department.

10. Write a SQL query to retrieve the department with the most employees, returning the department name and the employee count.