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.