Answering Simple Questions in SQL Coding Interviews

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.

Query Stack Overflow for Top 5 Tags and Children Posts

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.

Department Top Three Salaries

Given `Employee` and `Department` tables, we are asked to JOIN the tables and bring the top three employees (no ties) of each department.