How to get the latest from records with the same id?

Question

SQL

I'm using PhpMyAdmin, when I run a query

SELECT books.name, 
       books.pub_date, 
       books.id, 
       log_taking.returned_at, 
       log_taking.taken_at, 
       readers.last_name, 
       readers.first_name 
  FROM books
       JOIN log_taking ON books.id = log_taking.book_id
       JOIN readers ON readers.id = log_taking.reader_id

i get a table

books, log_taking and readers are database tables.
I want to get the latest entry of each id. That is, output only the lines underlined in red.

How to rewrite a query?

Answer 1

group by + order by