Search for names that occur more than once

You need to output the names that appear in the table at least twice.

CREATE TABLE people (
    person_id INT,
    full_name VARCHAR(100)
);

Sample data:

1, Igor
2, Anna
3, Peter
4, Igor
...

To get the result, use an aggregate function and the HAVING condition.