How to LEFT JOIN th add only one term, and not any, but the largest in this field?

Question

SQL

Let there be two tables:
Clients
-------
Ivan
Anna
Rita

Telephones
-------------
Ivan | 854
Ivan | 921
Rita | 321
Anna | 111

Only one number for each client should be added to the first tablet, and the largest among the numbers of this client.
That is, you need to get:
Ivan | 921
Anna | 111
Rita | 321.
Tell me, please, how to do this?

Answer 1

select
        u.*,
        ph.phone_max
    from users u
    left join (
        select 
                user_id, max(phone) phone_max
            from phones 
            group by user_id
    ) ph on u.user_id=ph.user_id

Answer 2

If you only want the phone number from the join table and nothing else, a subquery as a property using max.

select C.Name,
(select max(T.Phone) from Telephone T where T.Name = C.Name) Max_Phone
from Clients C

PS: If this is a practical task, and not a theoretical warm-up, then it should be confusing to use the customer name as the primary key in the customer table and as a foreign key in the phone table. In practice, identifiers are usually used to link tables.