Get the number of duplicate names and their frequency

Table – Employee Name Nitin Amit Gaurav Nitin Amit Output Nitin – 2 Amit – 2 Gaurav – 1