title: PSQL: Ignore duplicates, show most recent records in table
body: <p>I have psql table with the following scheme. Each instance appears several times in the table, with a creation date.</p>
  <p><img src="https://i.stack.imgur.com/B1Jj4.png" alt="sample CSV" /></p>
  <p>I am interested only in the most recent ones. So filtering duplicates, show only unique ones with most recent occurrence.</p>
  <p>My desired output would look like:</p>
  <p><img src="https://i.stack.imgur.com/screV.png" alt="output CSV" /></p>
  <p>Could you help me to find the proper query code?</p>
  <p>I appreciate your help in advance!</p>