Top 50 Rows and Min Values

Write SQL queries to retrieve the top 50 rows and the minimum two values from a specific column

Asked in the Technical stage. Use the provided case tables and treat priority_score as the specific column.

Output

1. Return one combined result set with result_type, case_id, case_title, priority_score, created_at, and category_name.
2. Include the 50 most recent cases, ordered by created_at descending and case_id descending for ties, followed by the two smallest distinct non-null priority_score values in ascending order.