Practice for the Dynamic arrays unit on a support team's tickets. Every answer goes in G2 and spills from there, so leave the cells to its right and below empty.
Pick the function from the task: FILTER for rows that match, SORT and SORTN for order and top lists, UNIQUE for distinct values, ARRAYFORMULA to run a calculation down a whole column, and braces to rearrange columns.