Top three items per category in SQL
For content in many categories, return the top three items in each category by an engagement measure, handling ties deliberately. Use a ranking window function partitioned by category.
MetaCodingNo answer yet. Write the first one; the best answer gets endorsed.