Task: PostgreSQL - Extract Last Row for Each ID

Task: PostgreSQL - Extract Last Row for Each ID: a task in Terminal-Lego-15k (Harbor dataset). Write a PostgreSQL query that extracts the most recent row for each unique id based on the date column from a given table.