#8 Finding Employees with the Same Last Name

Companies:

Rosatom

Themes:

SQLAggregationSubqueriesPractice

The Employee table is given:

last_name | first_name | middle_name
Popov Vlad Igorevich
Struk Artem Fedorovich
Moiseev Igor Nikolaevich
... ...

Return employees who have namesakes with the same last 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.