#533 Person Queries

Companies:

Raiffeisenbank

Themes:

JavaSQLCollections & GenericsAggregationPractice

There is a Person table:

Person(name, age)

Required:

Write an SQL query that returns each name and the maximum age for that name.
Write an SQL query that returns duplicates by the combination of name and age.
Implement the Java method:
```
List<Person> getTopAgeForName(List<Person> persons)
```
The method must reproduce the logic of the first SQL exercise: return the Person object with the maximum age for every name.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.