relational concepts.

Problem Statement:

Consider the following database and display the workers name with the count of workers having similar names.

Worker table

$|$ ID $|$ NAME $|$ DEPT $|$ SALARY $|$ DOJ $|$ BRANCH $|$

$|101|$ Amit$|$ Production $|45000\mathrm{.}00|2018-10-20|$ Bangalore $|$

$|102|$ Amit $|$ HR $|70000\mathrm{.}00|2019-07-02|$ Bangqlore $|$

$|103|$ sunita $|$ Management $|120000\mathrm{.}00|2019-01-11||$mysore $|$

$1105|$ sunita $|$IT $|67000\mathrm{.}00|2018-08-01|$ mysore $|$

$|106|$ mahesh $|$ Civi$|145000\mathrm{.}00|2019-09-20|$ Mumbai$|$