SELECT name, COUNT(name) AS cnt
FROM names
GROUP BY name
https://prnt.sc/x05pfi