How to return the last record of each sale

Question

How to return the last record of each sale considering the max(date)?

+---------+--------------------+---------------+
|venda    |Data                |id             |
+---------+--------------------+---------------|
|0000001  |2021-01-10 12:04:45 |0000000000001  |
|0000001  |2021-01-10 12:14:20 |0000000000002  |
|0000002  |2021-01-12 12:20:59 |0000000000003  |
|0000002  |2021-01-12 12:21:20 |0000000000004  |
|0000003  |2021-01-12 12:30:23 |0000000000005  |
|0000004  |2021-01-13 12:21:20 |0000000000006  |
|0000004  |2021-01-14 12:21:20 |0000000000007  |
|0000004  |2013-02-15 12:20:59 |0000000000008  |
+---------+--------------------+---------------+

SELECT
    *
FROM
    foo
WHERE
    DATA =(
        SELECT
            MAX( DATA )
        FROM
            foo
    )

this select I did returns only the last row of everything and should return:

+---------+--------------------+---------------+
|venda    |Data                |id             |
+---------+--------------------+---------------|
|0000001  |2021-01-10 12:14:20 |0000000000002  |
|0000002  |2021-01-12 12:21:20 |0000000000004  |
|0000003  |2021-01-12 12:30:23 |0000000000005  |
|0000004  |2013-02-15 12:20:59 |0000000000008  |
+---------+--------------------+---------------+

Answer 1

Try the following:

SELECT venda, max(data) from foo group by venda;