Task: Select ID with Max Date Grouped by Category in PostgreSQL

Task: Select ID with Max Date Grouped by Category in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). You need to write a PostgreSQL query that selects the id of the record with the maximum date for each category group from a given table.