LIMIT by GROUP in SQL (PostgreSQL) - How to Fetch Specific Data with ROW_NUMBER() Function

Alternating Category Order While Maintaining Groupings Based on Question ID in SQL