SQL Challenge: Employee Salary Analytics

[Onam]

Consider an employees table:

• employee_id (int)
• employee_name (varchar)
• department (varchar)
• joining_date (date)
• salary (decimal)

1. Highest Earner by Department: Find the employee with the highest salary in each department.
2. Average Salary by Department and Year: Calculate the average salary for each department per year.
3. Longest Serving Employee: Identify the employee with the longest tenure.

Please provide concise SQL queries for these analyses, emphasizing simplicity and efficiency. Thanks!

 

[WhiteCube]

That's not a challenge, that's just working for free.

Here's a challenge: Make a question that tricks ChatGPT into saying something stupid.

Just my opinion.