ORDER BY

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.