🧠 SQL Challenge of the Day! Think you’ve got solid SQL skills? Let’s put them to the test 👇 📌 Solve the problem in the image 🚫 Try NOT to peek at the comments before attempting ✅ Once you're done, drop your answer below 🔍 Then check the comments to see if you got it right! 💡 Pro tip: Don’t just aim for the correct answer—try optimizing your query too. Let’s see who gets it right! 💪 #SQL #DataAnalytics #CodingChallenge #LearnSQL #DataScience #TechSkills #PracticeMakesPerfect #LinkedInLearning #ChallengeYourself #Analytics
Select department, employee_name, salary From ( Select department, concat(first_name, ' ', last_name) as employee_name, salary, Rank() over (partition by department order by salary desc) as rnk From employee ) e Where rnk = 1;
SELECT department, CONCAT(first_name, ' ', last_name) AS employee_name, salary FROM employee QUALIFY RANK() OVER (PARTITION BY department ORDER BY salary DESC) = 1;
💬 Answer (Check only after attempting!) Here’s the correct SQL query to find the highest-paid employee in each department 👇 SELECT department, first_name AS employee_name, salary FROM employee e WHERE salary = ( SELECT MAX(salary) FROM employee WHERE department = e.department ) ORDER BY salary DESC; 🎯 If your answer matches this (or gives the same result), great job! 👏 Bonus points if you tried alternative approaches like using JOINs or window functions. Keep practicing and sharpening your SQL skills 🚀 #SQL #DataAnalytics #Coding #LearnSQL #TechCareers #DataSkills #QueryOptimization #PracticeSQL