SQL: The most repeated names and IDs of queries

Table structure
Requirements: ID and name name may be repeated multiple times. But with only one ID, you need to find the most repeated names and IDs. There are several names that can repeat the most, each with a different ID.

SELECT t.id,t.name,a.nu from T
Left JOIN
(SELECT Id,name,count () as Nu from-t GROUP by NAME) A on T.name=a.name
JOIN
(SELECT id,name,count () As num from T GROUP by NAME ORDER by num DESC LIMIT 1) C
WHERE A.nu=c.num

There is a better wording to ask.

SQL: The most repeated names and IDs of queries