Identification and counting of duplicate names in a table

There is a table name with columns id and name in the database. You need to write an SQL query that finds all values in the name column that occur more than once, and displays them along with the number of repetitions. The result should only show names with more than one occurrence, as well as the corresponding count.