How to organize a selection by date in SQLite?

Question

SQLite

Please tell me how to organize a selection from the table by two dates.
For example, there is a table "persons" (see attachment) Please tell me
how to select values ​​from the fields "name", "date1" from the table, but at the same time include records in the response only with the maximum date of the "date2" field.

That is, the response should look like this:

Example DB:
test_BDtest.db - Download file

Answer 1

Compose a subquery grouped by name and maximum date. Then to connect with the main table on the fields "name" and "date2".

Answer 2

select
t1.name,
t1.date1,
t2.date2
from persons t1
join (
  select
  name,
  max(date2) as date2
  from persons
  group by name
) t2 on t2.name = t1.name and t2.date2 = t1.date2