An interviewer recently commented about 50% of initial coding interviews failing what seemed to be very simple questions. I take a look at the questions and demonstrate the best way to answer them.
I want to find the top 5 tags (by post count) on Stack Overflow and include the top 5 posts per tag by score. For this, I will use the Stack Exchange Data Explorer.
Given `Employee` and `Department` tables, we are asked to JOIN the tables and bring the top three employees (no ties) of each department.